Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
dmohanty
Partner
Partner

Show the Max Month in the Model

Hi All,

I have a data set like this in which the latest Month is Mar-15 (in this example only)>

  

MonthAccount #Qty
Jan-151015000
Jan-151023500
Jan-151032500
Feb-152013200
Feb-152021400
Feb-152034800
Mar-153012200
Mar-153021900
Mar-15303

5200

I have a text object, which shows a label - 'Data is Current Through - Mar-15' (This value is dynamic and would show the latest month available in the model).

I used ='Data is current through: ' & MaxString({<[Month]=>}[Month].

But the problem is, when any Account# is selected which doesn't belongs to the Mar-15 (or the latest month), the Label changes to show that month belonging to the Account #.

How can I show the latest available month in the model, irrespective of the selections?

1 Solution

Accepted Solutions
maxgro
MVP
MVP

use set analysis with 1 (represents the full set of all the records in the application)

{1}

View solution in original post

2 Replies
maxgro
MVP
MVP

use set analysis with 1 (represents the full set of all the records in the application)

{1}

dmohanty
Partner
Partner
Author

This is Perfect!

Many thanks Massimo.