topic Re: Automatic Selection in filters in QlikView

Automatic Selection in filters

saniyask — Fri, 28 Apr 2017 06:36:49 GMT

Hi,

I have a requirement were i need to provide filters to user which will work like below.

Eg:-

if we have a filter for month (it is a fiscal calendar), and the user selects June then Apr, May & June all three months should be selected automatically, if user selects Sep then Starting from Apr to Sep all the months should get selected.

i.e whenever there is selection of month made, all the months starting from Apr to the selected moth should get selected.

Hope i was clear enough, Thanks in Advance!!

Regards,

Saniya

Re: Automatic Selection in filters

Anonymous — Fri, 28 Apr 2017 06:54:45 GMT

Like this Select All previous Months on ListBox | Qlik Community

Re: Automatic Selection in filters

Anil_Babu_Samineni — Fri, 28 Apr 2017 07:05:30 GMT

You meant to say You have data since Apr only

Try like below, Make sure you month format should be MMM then only this will work or else it may thread

Sum({<Month = {'>=$(=Min(Month)) <=$(Max(Month))'}>} Sales)

Re: Automatic Selection in filters

saniyask — Fri, 28 Apr 2017 09:02:09 GMT

Hi,

I am trying the same but the trigger is not working as expected, will retry and let you know.

Regards,

Saniya

Re: Automatic Selection in filters

saniyask — Fri, 28 Apr 2017 09:03:15 GMT

Have implemented the same to calculate YTD Sales, but the values are not matching once any selection on month is made

Re: Automatic Selection in filters

Anil_Babu_Samineni — Fri, 28 Apr 2017 09:41:06 GMT

Look at this? May be YTQ, QTD, MTD and WTD

Re: Automatic Selection in filters

snehamahaveer — Fri, 28 Apr 2017 09:43:33 GMT

Hi Saniya,

Use Sum({<Month = {'>=1 <=$(Max(Month))'}, Year = {'$(=max(Year))'}>} Sales)

Here the month is explicitly stated to start from April (if April is marked as month 1 - as its a fiscal year) upto the month selected.

Re: Automatic Selection in filters

saniyask — Fri, 28 Apr 2017 10:02:31 GMT

Hi,

Created an Inline for months and month no & it worked.. thanks.

Regards

Saniya

Re: Automatic Selection in filters

Fri, 28 Apr 2017 10:02:42 GMT

HI Saniya.

I suggest you make a inline for eg:

Load * inline [

MonthSelected, Month

Apr , 1

May, 1

May, 2

];

Re: Automatic Selection in filters

senpradip007 — Fri, 28 Apr 2017 10:36:16 GMT

Hope it will help.