topic Re: List box in QlikView

List box

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

Hi Expertise

I am using the below expression in my pivot table to display the weekly data . and this is a running total And I am using this part in my expression (Sum({1<Year *= {">2015"}>}0), 0) to populate the missing weeks so that I will be dipsplaying all the weeks and the result is accurate

The only problem I am facing is that the data is is diplaying from 2016 onwards , and if I select Year=2019 it doesn’t change.

The table should show the weekly data according to my Year list box selection .Can you please help me on this .

I got have fixed this using possible values .

Thanks in Advance

Re: List box

jonathandienst — Fri, 22 Nov 2019 09:13:39 GMT

The '1' ignores all selections, so the intersection is between everything and 2015, and your selection will not be considered. What goes wrong if you remove the '1' (or replace with '$')?

Re: List box

smilingjohn — Fri, 22 Nov 2019 09:45:04 GMT

Hi Jonty Thanks for the reply ,

If i replace 1 with $ or nothing then upon selecting year 2019 , it shows me only the weekly dates where there is data .

but i need to see all the weekly dates within it thats the reason i used 1.

I want to display all the week with list box selection . Please loo at the attachment

Thanks

Re: List box

smilingjohn — Fri, 22 Nov 2019 10:03:31 GMT

Any Help on this ?

Re: List box

Brett_Bleess — Thu, 05 Dec 2019 17:26:09 GMT

John, have a look at the following Design Blog post and I am including the base URL after that in case you want to do some further searching:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

You will need to use an expression in the set analysis instead of the year value in this case that ties to the list box etc...

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/FieldFunctions/getcurrentselections.htm

Regards,
Brett