Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
loganayaki
New Contributor II

Help Needed! - Basic Set Analysis - QTD Master item for current quarter with variables

Hello Friends,

Need some help with Set Analysis!!

I am trying to compute the QTD Value for a measure. I have created it as a Master item. I need it to compute for the current quarter. I have variables defined which give the current quarter. I have referenced these variables in the Master item. But for some reason if I pull the Master item in a table it displays only 0.

This is the formula in my Master item

Sum({$<Year=, Quarter=, Month=, [Cal Quarter Number]={$(vCurrentQtr)}, [Cal Month Number]={"<=$(vCurrentPeriod)"}>} [Reported Sales])/1000

This is the table without the measure which shows the right values

8-14-2017 5-15-37 PM.jpg

This is the table with the measure which shows the 0 values

8-14-2017 5-17-51 PM.jpg

1 Solution

Accepted Solutions

Re: Help Needed! - Basic Set Analysis - QTD Master item for current quarter with variables

I think you don't have any data for Reported ACV when quarter number = 77

Capture.PNG

View solution in original post

5 Replies
loganayaki
New Contributor II

Re: Help Needed! - Basic Set Analysis - QTD Master item for current quarter with variables

Can someone help on this please?

Re: Help Needed! - Basic Set Analysis - QTD Master item for current quarter with variables

Would you be able to share your app with us?

loganayaki
New Contributor II

Re: Help Needed! - Basic Set Analysis - QTD Master item for current quarter with variables

Hi Sunny,

Attached is the qvf file.

Thanks!

Re: Help Needed! - Basic Set Analysis - QTD Master item for current quarter with variables

I think you don't have any data for Reported ACV when quarter number = 77

Capture.PNG

View solution in original post

loganayaki
New Contributor II

Re: Help Needed! - Basic Set Analysis - QTD Master item for current quarter with variables

Hi Sunny,

You are right! It was indeed an issue with the dataset.

Thanks!