Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
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