Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

shamitshah
Contributor

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

Re: Date expression

try this

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

2 Replies

Re: Date expression

try this

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

shamitshah
Contributor

Re: Date expression

Thanks Kushal!

Regards

Shamit

Community Browser