topic dual function in QlikView

dual function

JMAROUF — Sun, 14 Feb 2021 14:33:37 GMT

Hello every one,

I am using dual function in load script to sort some values in pivot table using month-Year, the problem is that dual function returns always january as month, this is my script:

DUAL(month(DATEEVENEMENT)&'-'&Date(DATEEVENEMENT,'YY'),Year(DATEEVENEMENT)) AS MONTH_Ev

there is the output:

janv.-19 janv.-20 janv.-21

Note that month(DATEEVENEMENT) works well.

Can anyone help please.

Re: dual function

Saravanan_Desingh — Sun, 14 Feb 2021 15:00:39 GMT

Try this.

DUAL(month(DATEEVENEMENT)&'-'&Date(DATEEVENEMENT,'YY'),Month(DATEEVENEMENT)) AS MONTH_Ev

Re: dual function

Vegar — Sun, 14 Feb 2021 17:01:04 GMT

You can only store one text value per numeric in a dual field . You are using year as numeric value for all months and you will get the same text for all 2020 values and all 2021 values etc.

An alternative approach for this could be using this expression.

Date(monthname(DATEEVENEMENT), 'MMM-YY') as MONTH_Ev

Re: dual function

JMAROUF — Sun, 14 Feb 2021 20:34:56 GMT

Thank you @Saravanan_Desingh for the reply, but that doesn't work,