Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dineshmdane
New Contributor III

Set Analysis data type equivalent

Hi All,

Does data type should be same in set analysis?

Example:

SUM({<oderdate={'<=201712'}>}Sales)

oderdate is in text format and 201712 is in date format.

The above one is not working.Kindly help

Thanks & Regadrs,

Dinesh M

5 Replies

Re: Set Analysis data type equivalent

Hi,

Yes it should be same.

Regards,

Kaushik Solanki

OmarBenSalem
Esteemed Contributor

Re: Set Analysis data type equivalent

Try to put it btwn doubles quotes as a first test.

Re: Set Analysis data type equivalent

orderdate is text format? If that is true this may not work... but are you sure it is text? may be it is a number?

pradosh_thakur
Valued Contributor III

Re: Set Analysis data type equivalent

May be try this

SUM({<oderdate={"=(date#(oderdate,'YYYYMM')<=DATE#(201712,'YYYYMM'))'}>}Sales)

dineshmdane
New Contributor III

Re: Set Analysis data type equivalent

Hi Sunny,

Yes, orderdate is in text format.

Community Browser