topic Alternative to inline wizard for creating quarter field from Year dimension in QlikView

Alternative to inline wizard for creating quarter field from Year dimension

rajtechnocraft — Wed, 06 Jul 2011 07:27:19 GMT

Dear Community,

Just wanted to know the alternative ways to create quarter dimension from Year field..

I have used inline wizard but it takes time to refresh .Just wanted to know if there is an efficient way to do the same so that i can reduce the reload time of the application.

Regards

Arvind

Alternative to inline wizard for creating quarter field from Year dimension

kaushiknsolanki — Wed, 06 Jul 2011 07:32:13 GMT

HI,

If you have date field, you can use following to get the quarter.

Load

DateField,

'Q' & Ceil(Month(DateField)/3) AS CalendarQuarter

From xyx.

Regards,

Kaushik Solanki

Alternative to inline wizard for creating quarter field from Year dimension

rajtechnocraft — Wed, 06 Jul 2011 07:41:20 GMT

Dear Kaushik,

Is this much faster than inline wizard i mean from performance point of view

Regards

Arvind