topic Bar chart not reflecting in QlikView

Bar chart not reflecting

dandaanilreddy — Wed, 25 Nov 2020 16:16:04 GMT

Hello Qlik Developers

I have a app in which i have 6 sheets in one of the sheet i have a list box that has 1, 3,6 and 9 months as values. on the activation sheet i wrote field trigger to display 1 month as default. By the trigger if i select any month and go to any sheet and come to this sheet the selection should go to 1 month its working fine but the problem is if i select any of the month except 1 month and go to any sheet any come back the selection is going to 1 month but the values in the bar chart are not reflecting its still showing the other month what i selected. Can someone help me please.

Thanks

Anil

Re: Bar chart not reflecting

MK9885 — Fri, 11 Nov 2016 17:32:42 GMT

You doing this in Qlik Sense or QlikView?

What extension you using for assigning triggers or variables?

Re: Bar chart not reflecting

dandaanilreddy — Fri, 11 Nov 2016 17:45:41 GMT

Hi Arvind

I am doing it in qlikview. I have another variables in trigger like below.

Direct uplift

= If(ToggleSort=1,sum({<BillingRegionType = {"Direct"}>}growth_1_month),If(ToggleSort=2,sum({<BillingRegionType = {"Direct"}>}growth_3_month),

If(ToggleSort=3,sum({<BillingRegionType = {"Direct"}>}growth_6_month),If(ToggleSort=4,sum({<BillingRegionType = {"Direct"}>}growth_9_month)))))

I think this is causing the issue as i wrote field trigger for 1 month. I think i need to remove all if conditions.

Thanks

Anil

Re: Bar chart not reflecting

MK9885 — Fri, 11 Nov 2016 17:48:32 GMT

Post this question in Qlikview forum. By mistake you've posted it in Qlik Sense....

You'll get replies there...

Maybe stalwar1‌ can help you better in set expressions.

Thanks.

Re: Bar chart not reflecting

dandaanilreddy — Fri, 11 Nov 2016 17:50:14 GMT

My mistake. I have moved it to qlikview

Thanks

Anil

Re: Bar chart not reflecting

sunny_talwar — Fri, 11 Nov 2016 17:52:54 GMT

The above is your bar chart expression? What is your field name where you are making 1,3,6,9 month selection?

Re: Bar chart not reflecting

dandaanilreddy — Fri, 11 Nov 2016 18:09:07 GMT

Finally i got it, i removed if condition for all the variable and set the variable to sum({<BillingRegionType = {"Direct"}>}growth_1_month).

Thanks all.

Thanks

Anil