Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following expression in QlikView ,
=num(Count (DISTINCT if(OrderDate>=('01/07/2015'),InvoiceNumber)),'#,##0','.',',')
which I want to apply in Qlik Sense.
I tried the following, but not getting any result
Count(Distinct {<OrderDate = { "<$(=>01/07/2015)" }>}InvoiceNumber)
Any idea on what the correct expression should be?
Thanks
Shamit
try this
Count(Distinct {<OrderDate = { ">=01/07/2015" }>}InvoiceNumber)
try this
Count(Distinct {<OrderDate = { ">=01/07/2015" }>}InvoiceNumber)
Thanks Kushal!
Regards
Shamit