topic Display expressions based on listbox selections in QlikView

Display expressions based on listbox selections

retko1985 — Mon, 05 Feb 2018 09:39:01 GMT

Hello,

I am using Set analysis for each line in Line chart, like this Sum({<Country = {'USA'}>}Sales)

Now I want to conditionally enable each line when I Make a Selection in Country Listbox, also when no selection is made, all lines should appear.

Can someone help me to write to condition on expressions?

Attaching the example case in QVW.

Thank you.

stabben23 — Mon, 05 Feb 2018 09:49:32 GMT

Hi,

I dont know if this fit Your requirement, but if you add Country as Dimension and just use Sum(Sales) as Expression.

otherwise explain a little bit more what you try to achive.

BalaBhaskar_Qlik — Mon, 30 Jul 2018 12:14:00 GMT

Dim - Country,

Expr - Sum(Sales)

Otherwise, if you've other dimensions too, then use the below:

Sum({<Country = {'$(=GetFieldSelections([Country]))'}>}Sales)

neelamsaroha157 — Mon, 30 Jul 2018 13:09:40 GMT

Check this out.