Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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

0 Replies