Show the Max Month in the Model

dmohanty — Wed, 09 Sep 2015 16:04:53 GMT

Hi All,

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

Month	Account #	Qty
Jan-15	101	5000
Jan-15	102	3500
Jan-15	103	2500
Feb-15	201	3200
Feb-15	202	1400
Feb-15	203	4800
Mar-15	301	2200
Mar-15	302	1900
Mar-15	303	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?

Re: Show the Max Month in the Model

maxgro — Wed, 09 Sep 2015 16:09:42 GMT

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

{1}

Re: Show the Max Month in the Model

dmohanty — Wed, 09 Sep 2015 16:34:19 GMT

This is Perfect!

Many thanks Massimo.

topic Show the Max Month in the Model in QlikView

Show the Max Month in the Model

Re: Show the Max Month in the Model

Re: Show the Max Month in the Model