topic Re: How to Show two date columns in one drop-down list in sas va? in SAS Visual Analytics

How to Show two date columns in one drop-down list in sas va?

NiravC — Fri, 28 Jun 2019 06:20:17 GMT

Hello Experts,

I want to create one drop-down list by using two date columns.when I click the drop-down list then value should be "Order Date" & "Shipping Date". Is this Possible?

I have two date columns: 1) Order Date

2) Shipping Date

Thanks In Advance.

Nirav

Re: How to Show two date columns in one drop-down list in sas va?

Madelyn_SAS — Mon, 01 Jul 2019 20:22:44 GMT

Each drop-down list control (or any control) can have only one data item assigned to it. You could place two drop-down lists in a single prompt container.

Re: How to Show two date columns in one drop-down list in sas va?

NiravC — Tue, 02 Jul 2019 04:05:12 GMT

But I want when I click drop down list then value should be "Order Date" & "Shipping Date". I don't want the proper date value in drop-down list object. And Also I click the drop-down list and i select "Order Date" then all dates should be shown in the Slider Object.

So, I don't want to show proper date value in drop-down list. This is the actual task.

Re: How to Show two date columns in one drop-down list in sas va?

Madelyn_SAS — Tue, 02 Jul 2019 13:22:50 GMT

This sounds like you want to choose which measure values should be displayed in a slider. This blog post is the only solution that I can think of that would be close to what you are asking (if I understand correctly.)

Use parameters to pick your metric in Visual Analytics Reports