topic Re: Format Date in Set analysis in QlikView

Format Date in Set analysis

anuradhaa — Mon, 02 Nov 2015 07:13:51 GMT

I want to use below expression but it gives error,

please help me to correct it

count({$<Date(MY_date,'YYYY-MM-DD')={$(=Max(MY_date)-1)}>}Country)

Re: Format Date in Set analysis

avinashelite — Mon, 02 Nov 2015 07:18:08 GMT

you should set the left hand side of the expression in the script and then need to compare the same

Date(MY_date,'YYYY-MM-DD') set this in the script and then use

or try once like this :

count({$<Date(MY_date,'YYYY-MM-DD')={"$(=Max(MY_date)-1)"}>}Country)

Re: Format Date in Set analysis

tresB — Mon, 02 Nov 2015 07:26:02 GMT

You can't put an expression in the LHS section of set analysis, that has to be a field (script generated). Hence, you better try to format the date in the RHS of your set comparison, like:

count({$<MY_date={"$(=Date(Max(MY_date)-1), 'DD-MM-YYYY') "}>}Country)

Change the date format as it is with My_date field.

Re: Format Date in Set analysis

jagan — Mon, 02 Nov 2015 07:37:30 GMT

Hi,

You cannot do any formatting or any calculations in Left hand side of the set analysis expression, instead you have make the changes in the RHS as required like below

count({$<MY_date={"$(=Date(Max(MY_date)-1, 'YYYY-MM-DD'))"}>}Country)

Note: YYYY-MM-DD replace with actual MY_Date format, so that the expression works.

Regards,

Jagan.

Re: Format Date in Set analysis

Kushal_Chawda — Mon, 02 Nov 2015 07:38:49 GMT

try this

count({$<MY_date={"$(=date(Max(MY_date)-1,'YYYY-MM-DD'))"}>}Country)

Re: Format Date in Set analysis

smirkinaa — Mon, 02 Nov 2015 07:50:11 GMT

You connot use expressions like "set_identifier". I suggest you to prepare additinal field with suitable format of date in script and use it in set analysis. Moreover, using numeric presentation of date is more effective then text format of date.