Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
shamitshah
Partner - Creator
Partner - Creator

Date expression

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

1 Solution

Accepted Solutions
Kushal_Chawda

try this

Count(Distinct {<OrderDate = { ">=01/07/2015" }>}InvoiceNumber)

View solution in original post

2 Replies
Kushal_Chawda

try this

Count(Distinct {<OrderDate = { ">=01/07/2015" }>}InvoiceNumber)

shamitshah
Partner - Creator
Partner - Creator
Author

Thanks Kushal!

Regards

Shamit