Is it possible to change the X axis dimention usine select option?

[#1]

Dear Friends,

I have a scatter chart with X axis as end date.

There are two date available end date & review date.

we want to create similar with review date but not in a different tab.

Is it possible to change the X axis dimention usine select option? like End Date, Review Date & accordingly generate the chart?

Best Regards

Rahul

[swuehl]

If you are using QlikView11 and up, you can use conditional dimensions (check the demo app What's New in QV11 on how to do this).

Or, alternatively, create an input box with a variable and predefined values that match your dimension field names.

Then expand your variable in your dimension definition.

[#3]

Hi Swuehl,

Many Thanks for your input.

I am using QV11, but unfortunately was not able to find "What's New in QV11" QV document.

Enclosed is the Qlikview file with two scatter chart. I want one scatter chart with an option R date1, R date2 to select & according it takes the X axis.

Please help!

Best Regards

Rahul Kale

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[#5]

Dear Gysbert

Many thanks for your inputs.

It is working fine!

Best Regards

Rahul Kale