Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Potential Set Analysis Issue


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

I have some data as below:


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


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


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!


0 Replies