topic Displaying date in "class" function label in QlikView

Displaying date in "class" function label

azimabadi — Mon, 16 Apr 2012 10:51:44 GMT

Hi all

i have a pivot table and in it's Dimensions i have used a class function for classification as follow:

class ( myDate , varPeriod , 'Date' , -1 )

myDate is a "Date" type. In labels of each class shown in pivot table i have something like this :

40915 <= Date < 40919 40919 <= Date < 40923 ...

i need to customize labels. for example something like :

07.01.2012 11.01.2012

i need to mention that ( 07.01.2012 ~ 40915 ) and ( 11.01.2012 ~ 40919 ).

at least i need one of the following forms:

07.01.2012 <= Date 11.01.2012 <= Date

07.01.2012 <= Date < 11.01.2012 11.01.2012 <= Date < 15.01.2012

how can i do that?

thank you so much.

Displaying date in "class" function label

nilesh_gangurde — Mon, 16 Apr 2012 11:19:47 GMT

Hi Peyman,

use this :

=Date(subfield(text(class(myDate,$(varPeriod),' ')),'<=',1),'DD-MM-YYYY') & ' To ' &

date(subfield(text(class(myDate,$(varPeriod),' ')),' < ',2),'DD-MM-YYYY')

Regards,

Nilesh Gangurde

Displaying date in "class" function label

azimabadi — Mon, 16 Apr 2012 11:26:07 GMT

Hi Nilsen,

Thank you for answer.

but where i have to enter the expersion? the "Label for Column/Row" in peresentation tab of chart properties is disabled.

can you please explain where i need to write the expersion you offered?

Displaying date in "class" function label

SunilChauhan — Mon, 16 Apr 2012 11:26:30 GMT

try this

class ( myDate , $(varPeriod ), 'Date' , -1 )

hope this helps

Displaying date in "class" function label

azimabadi — Mon, 16 Apr 2012 11:33:19 GMT

thank you Sunil, but the second parameter is 'interval'. this doesn't help anymore.

we need to find a way to convert the displaying format of myDate that here is Integer not Date.

Re: Displaying date in "class" function label

nilesh_gangurde — Mon, 16 Apr 2012 11:34:42 GMT

Hi Peyman,

On the Dimension tab u will see the "Add Calculated Dimension". Click on it and paste the above stuff there.

then add the expression For Example : sum(Sales ) in the expression tab.

Regards,

Nilesh Gangurde

Displaying date in "class" function label

azimabadi — Mon, 16 Apr 2012 11:45:35 GMT

Thanks againe Nilesh,

i did so. my expersion is like :

sum( {<A ={"1"}>} v1 - v2 )

but in pivot table i get the error message "Error in calculated dimension." and i loss the clasification.

Displaying date in "class" function label

SunilChauhan — Mon, 16 Apr 2012 11:50:07 GMT

aggr(sum( {<A ={"1"}>} v1 - v2 ),idfield)

hope this helps

Displaying date in "class" function label

azimabadi — Mon, 16 Apr 2012 11:53:28 GMT

what do you mean exactly Sunil?

Displaying date in "class" function label

SunilChauhan — Mon, 16 Apr 2012 11:55:53 GMT

aggregate expression by you key fields

so that it should show in your dimension

hope this helps

Re: Displaying date in "class" function label

nilesh_gangurde — Mon, 16 Apr 2012 11:58:18 GMT

use this :

Date(subfield(text(class(num(myDate),$(varPeriod),' ')),'<=',1),'DD-MM-YYYY') & ' To ' & date(subfield(text(class(num(myDate),$(varPeriod),' ')),' < ',2),'DD-MM-YYYY')

U are getting that error msg because of the equel Sign. Please remove the "=" equal sign and try with the above expression.

To test the class function is working or no put tha basic expression(in expression tab) first and then go for deep analysis.

Regards ,

Nilesh Gangurde

Displaying date in "class" function label

azimabadi — Mon, 16 Apr 2012 12:45:13 GMT

this was useful, but the classification created by this expression is not waht is expected and resulted classification and calculation are false.

there is not any way we change the date format in original class function?

Re: Displaying date in "class" function label

nilesh_gangurde — Mon, 16 Apr 2012 12:54:04 GMT

The above expresssion changes the date format of Original class function only.

Can you attach the qvw file.

So i can help you.

Regards,

Nilesh Gangurde

Displaying date in "class" function label

azimabadi — Mon, 16 Apr 2012 12:58:01 GMT

This is customer data and i am not allowed to share it.

but i make a qwv with sample data and post it in a few minutes.

Re: Displaying date in "class" function label

azimabadi — Mon, 16 Apr 2012 13:15:46 GMT

Here is my sample. I have explained the expected labels in text objects below each column.

thank you so much for help againe