Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Partner
Partner

Re: How to read multiple values from a filter pane

Qvf in attachments.

woshua5550
Contributor III

Re: How to read multiple values from a filter pane

sorry , I typed wrongly ,this would be ok

Partner
Partner

Re: How to read multiple values from a filter pane

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

sample output.JPG

Partner
Partner

Re: How to read multiple values from a filter pane

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.

Highlighted
woshua5550
Contributor III

Re: How to read multiple values from a filter pane

oh ~ I got you see this

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

Partner
Partner

Re: How to read multiple values from a filter pane

Thanks Lou Needed this desperately ...

Partner
Partner

Re: How to read multiple values from a filter pane

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
Contributor III

Re: How to read multiple values from a filter pane

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

Partner
Partner

Re: How to read multiple values from a filter pane

Hi Lau,

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