Label

[shamitshah]

Hi,

I have the following expression and I want to the label it as Orders with the  Max Date

Expression:

count(Distinct{<PickDate={"$(=Max(PickDate))"},LIT_Status={'4'}>}PurchaseOrder)

The Max(PickDate) would be the latest date e.g. 11 June 2016, hence the label should appear as "Orders 11 June 2016"

Any ideas?

Thanks

Shamit

[Gysbert_Wassenaar]

Afaik it's not possible yet to use expressions as labels in Qlik Sense.

[shamitshah]

Thanks for the info.

Shamit

[idogridish2 · Accepted solution]

hi shamitshah

you can use ValueList(vMaxdate) as dimension with a variable in it

that will hold the max date like:

vMaxdate = max(pickdate).

and in the exprission:

if(ValueList(vMaxdate) = vMaxdate,count(Distinct{<PickDate={"$(=Max(PickDate))"},LIT_Status={'4'}>}PurchaseOrder))

regards

[shamitshah]

Thanks Ido,

Works perfectly.

Regards

Shamit

[idogridish2]

Great!,

what kind of object is this?

[shamitshah]

Just a simple KPI Chart object.