topic Re: Expression names in QlikView

Expression names

danielnevitt — Thu, 22 May 2014 11:09:27 GMT

Hi,

I have used the quartname command to create a field which shows results as Jan-Mar 2013, Apr-Jun 2013, Jul-Sep 2013 etc.

Is it possible to label this field Q1 2013, Q2 2013, Q3 2013 etc?

Thanks,

Daniel

magavi_framsteg — Thu, 22 May 2014 11:50:08 GMT

Don't you want the field to be named "Quarter"?

And in your Quarter field, you have rows such as Q1 2013, Q2 2013 etc?

Using this approach, you can use your Quarter field as a dimension in your datamodel and visualize your calculations by Quarter.

The approach which you suggested, to have separate fields for Q1 2013 and Q2 2013 etc., makes no sense in a fact - dimensional data model.

senpradip007 — Thu, 22 May 2014 11:58:13 GMT

Use the following in script:

(Calendar_Year&'-'&'Q'&Ceil(Month/3), Calendar_Year*100+Ceil(Month/3)) as QuarterYear