Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
saniyask
Creator
Creator

Automatic Selection in filters

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

1 Solution

Accepted Solutions
saniyask
Creator
Creator
Author

Hi,

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

Regards

Saniya

View solution in original post

9 Replies
Anonymous
Not applicable

Anil_Babu_Samineni

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)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
saniyask
Creator
Creator
Author

Hi,

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

Regards,

Saniya

saniyask
Creator
Creator
Author

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

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
snehamahaveer
Creator
Creator

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.

saniyask
Creator
Creator
Author

Hi,

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

Regards

Saniya

Not applicable

HI Saniya.

I suggest you make a inline for eg:

Load * inline [

MonthSelected, Month

Apr , 1

May, 1

May, 2

];

senpradip007
Specialist III
Specialist III

Hope it will help.