Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
MVP
MVP

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

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?

MVP
MVP

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!

MVP
MVP

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

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!