topic Re: Calculation Condition in QlikView

Calculation Condition

Thu, 04 Sep 2014 14:19:04 GMT

Hi,

I got a listbox built from the following expression

=if(Aging < 1, 'Current', if (Aging >=1, 'Later'))

Now I want to add a calculation condition to my chart.

My chart should show up only when only one value is selected in this listbox.

Please help me with it.

Regards,

Saurabh

MK_QSL — Thu, 04 Sep 2014 14:22:40 GMT

use below in script...

if(Aging < 1, 'Current', if (Aging >=1, 'Later')) as Value

Now for chart, go to Layout Tab >> Conditional

use below expression

GetSelectedCount(Value) > 0

JonnyPoole — Thu, 04 Sep 2014 14:24:40 GMT

It should still work that you can use getselectedcount(Aging) > 0 to determine if a selection has been made.

On the chart properties go to the layout tab and enter a conditional show/hide expression on the right side of

getselectedcount(Aging) > 0

Thu, 04 Sep 2014 17:50:14 GMT

When i code "as Value" then list box does not show anything.