topic Conditional in QlikView

Conditional

Tue, 06 Dec 2011 14:45:42 GMT

I have two charts and used a "show conditional" under layout and have an input box. I want to add a third chart that does the same thing (only shows when I select it in the input box and call it 'Sum Trendline Totals") Do I have to go into Variable overview?

(In Show Conditional)

if(var_chart='Average Trendline Totals',1,0)

if(var_chart='All Figures',1,0)

Conditional

erichshiino — Tue, 06 Dec 2011 14:50:53 GMT

Hi,

The show condition will be?

if(var_chart='Sum Trendline Totals',1,0)

You need to add this option in the inputbox.

In the inputbox, go to settings -> Constraints and include another value in the box below the 'Listed Values' check box (that should be marked)

Hope this helps,

Erich

Conditional

Tue, 06 Dec 2011 14:56:04 GMT

Yeah I tried that. It lists it in the input box but when I select it, no chart appears.

Conditional

vijay_iitkgp — Mon, 19 Dec 2011 07:45:52 GMT

Hi,

If you want to show one chart at a time by using input box then you can use only var_chart1='Sum Trendline Totals' in show condition. When you type 'Sum Trendline Totals' in input box the chart will get populated.

Regards

VIjay