Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

deerhunter
Contributor

Indirect Set Analysis challenge

I'm struggling with a set of KPI's in the App. I added a PDF file as an attachment to better explain what is happening.

The PDF will show some KPI’s circled in Red with set analysis statements that use the set identifier = 1 to ignore current selections, but you will notice that the circled expression in blue changes when the user picks a year button or FYear filter. That effects the set analysis statement where the two calculations drive the SA. I require the output to not change upon selecting anything. If you select Quarter or Months it works correctly and doesn’t change the KPI’s. if you pick a  year button or FYear filter it effects the KPI circled in red. (NG) ☹

I’m including some images to show before & after in the PDF file included…

Any ideas, I’m including the App for your review. If you can make any corrections and send it back that would be really helpful to many & insightful to all.

The button extension used = sense-FieldUI-master

Thanks team

Tags (1)
1 Solution

Accepted Solutions

Re: Indirect Set Analysis challenge

Try this

Sum({1<[ACCOUNTING_DT.FiscYR.Date]={">=$(=AddYears(YearStart(Max({1}[ACCOUNTING_DT.FiscYR.Date]),0,7),-1))<=$(=AddYears(Today(),-2))"} >} AMOUNT)

3 Replies

Re: Indirect Set Analysis challenge

Try this

Sum({1<[ACCOUNTING_DT.FiscYR.Date]={">=$(=AddYears(YearStart(Max({1}[ACCOUNTING_DT.FiscYR.Date]),0,7),-1))<=$(=AddYears(Today(),-2))"} >} AMOUNT)

deerhunter
Contributor

Re: Indirect Set Analysis challenge

That did it my friend, thank you

Re: Indirect Set Analysis challenge

Super... please close the thread by marking the correct response above.

Best,

Sunny

Community Browser