Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Potential Set Analysis Issue

Hi

This might not be a set analysis question.... It probably my naivety!

I have some data as below:

Data.jpg

And I'm trying to Report Current Month chosen, prior month and prior year, as below!

QV.jpg

I have created some variable to help me get to this point:

var.jpg

But i'm getting some issues - If i leave my choices empty it's all good (it defaults to the max, asin the screen shot below) - the minute I choose a year and a month from the selection, the Prior Month figure goes to zero... I suspect its as there is no longer data for months other than the ones I've chosen in the data set - there obviously is in the source data....  If this is the case how can I solve the issue?

The expressions is below:

Prior Month: =Num(Sum({<  DataYear = {$(=vPriorMonth_Year)} , DataMonth = {$(=vPriorMonth_Month)}     >} NewBusinessInMonth),'#,##0')

The data is month by month - ie a Monthly position has been derived in the back end database, so I am comparing month on month!


Cheers

Labels (1)
0 Replies