Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Afaik it's not possible yet to use expressions as labels in Qlik Sense.
Thanks for the info.
Shamit
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
Thanks Ido,
Works perfectly.
Regards
Shamit
Great!,
what kind of object is this?
Just a simple KPI Chart object.