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: 
siddharthsoam
Partner - Creator II
Partner - Creator II

How to read multiple values from a filter pane

Hi

Please  tell me how can I fetch multiple values from a filter pane . I have a accounting period filter from which I want to calculate a certain measure of the previous selected period.

counting period.JPG

For example if I select counting period as 4,5 it should return me sum(revenue) for 4 and 3 month.

Thanks in advance

18 Replies
siddharthsoam
Partner - Creator II
Partner - Creator II
Author

Qvf in attachments.

woshua5550
Creator III
Creator III

sorry , I typed wrongly ,this would be ok

siddharthsoam
Partner - Creator II
Partner - Creator II
Author

Quarter 1 data is still not showing up . Don't know how to proceed. Expected output should be like this.

sample output.JPG

siddharthsoam
Partner - Creator II
Partner - Creator II
Author

Thanks dave looked into the wrong file..:)... But not able to change data by altering accounting period, when I change the expression to this

IF(H1='Recent Completed Quarter' ,Sum([Service Rev]),Sum({<Quaters={$(=Concat(Distinct Quaters-1,','))}, [Accounting Period]={$(=Concat(Distinct [Accounting Period]-3,','))}>}[Service Rev]))

No data shows up under Q1 . Using your expression I am able to get Q1 under recent but when I change the accounting period(month) under a quarter ,it shows null value. I want that when I select quarter Q2 and accounting period 4,5 under recent ,it shows me quarter 1 , accounting period 1,2 under previous header.

woshua5550
Creator III
Creator III

oh ~ I got you see this

btw , if you don't select anything ,"pervious completed quarter" will show Q1+Q2+Q3 data

siddharthsoam
Partner - Creator II
Partner - Creator II
Author

Thanks Lou Needed this desperately ...

siddharthsoam
Partner - Creator II
Partner - Creator II
Author

Hi Lau,

I am also having some trouble putting in condition for displaying year-2016 Quarter 4 data in previous when user selects  fiscal year-2017 and quarter 1. Can you tell me where I have to put the if condition ?

Thanks in advance. Appreciate your help and patience on this

woshua5550
Creator III
Creator III

Well , I see

this will be quite different from what we did, I think we'd better figure it out relying on a better data set

so plz attach your data source file which named "FY16.xlsx" and "FY17.xlsx" in my view

siddharthsoam
Partner - Creator II
Partner - Creator II
Author

Hi Lau,

Got it after trying certain possibilities , simple if condition outside our measure made it to work