topic Re: restrict to specific in QlikView

restrict to specific

soniasweety — Sat, 16 Nov 2024 01:43:01 GMT

Hi All,

i want to restrict the listbox months to 12 months only how to do this? so listbox should show 1year data only below is the format.

Monthfield

201905

201904...

201804

Re: restrict to specific

Arthur_Fong — Thu, 12 Dec 2019 06:33:17 GMT

Try this in listbox expression:

=if(aggr(rank([Month]),[Month])<13,[Month])

Replace [Month] with your month dimension.

Re: restrict to specific

soniasweety — Thu, 12 Dec 2019 06:56:07 GMT

Now in my data i have below yearmonths but when i apply above code i can see only max month.

201707
201706
201705
201704
201703
201702
201701
201612
201611
201608
201607
201606
201605
201604
201603
201602
201601
201512
201511
201510
201509
201507
201506
201505
201504
201503
201502
201501
201412
201411

Re: restrict to specific

Arthur_Fong — Thu, 12 Dec 2019 07:09:44 GMT

No issue with me:

Re: restrict to specific

soniasweety — Thu, 12 Dec 2019 07:37:57 GMT

yeah its working. but there is one issue i can see.

like i have select in field trigger its taking max(month) so when i open the dashboard that listbox showing only max month .. other 11 months is not showing

and when i deselect the max month then its showing 12months 😞

Re: restrict to specific

Brett_Bleess — Wed, 18 Dec 2019 19:14:48 GMT

Sonia, any chance you can attach an example app or the actual app with reduced data, I think that will help on this one, as you apparently have something in particular going on in the background, but without being able to see your data model and the setup of the sheet objects, it is a bit difficult for folks to gather what to tell you to address things. Arthur is definitely on the right track, but I think if you can get the additional info, he can likely give you a final answer to resolve things, and he is a better resource on this one than am I, just FYI, he is a much better developer! 🙂 Someone else may shout too given I am posting which will kick things up in the list again, but if you can do the app etc., I think that will do the trick.

Regards,
Brett