topic Re: How to Combine 2 fields as Dimensions? in QlikView

How to Combine 2 fields as Dimensions?

300sss300 — Wed, 25 Nov 2020 16:16:04 GMT

I have 02 fields Year and Quarter

2016 Q1

2016 Q2

2016 Q3

2016 Q4

2015 Q1

2015 Q2

. .

I want to use "YearQuarter" as Dimension like 2015 Q1 2016 Q1

How I can combine both Year and Quarter so that it should become 01 field to be used as Dimension.

Regards,

stalwar1‌

Re: How to Combine 2 fields as Dimensions?

oknotsen — Tue, 03 May 2016 12:32:53 GMT

Glue them together in your loadscript:

Year & Quarter as YearQuarter,

Re: How to Combine 2 fields as Dimensions?

sunny_talwar — Wed, 04 May 2016 02:31:37 GMT

I suggest combining them in the script just like Onno‌ mentioned, but I would suggest using a Dual function so that you can sort them in your dimension without using any sort expression

LOAD Year,

Quarter,

Dual(Year & ' ' & Quarter, Num#(Year & Num(Right(Quarter, 1), '00'))) as YearQuarter

FROM Source;

Re: How to Combine 2 fields as Dimensions?

SunilChauhan — Wed, 04 May 2016 04:20:09 GMT

Year &' '&Quarter as New field .

but i will suggest go with Sunny T solution above. as it will allow you to sort as numbers.

Re: How to Combine 2 fields as Dimensions?

tresB — Wed, 04 May 2016 04:45:32 GMT

Ideally one should try with proper date function like QuarterName() which gives output in a bit different form like:

QuarterName ( '2005-10-29' ) returns 'Oct-Dec 2005'

However, if your format matters, you could use Dual() to give it a flexibility of sorting in the front-end without much manual effort. Hence, try like:

Dual( Year&'-'&Quarter, QuarterName(Date)) as YearQuarter

Re: How to Combine 2 fields as Dimensions?

300sss300 — Wed, 04 May 2016 05:35:22 GMT

Thanks !!!

Re: How to Combine 2 fields as Dimensions?

300sss300 — Wed, 04 May 2016 05:36:30 GMT

Thanks !!!

Re: How to Combine 2 fields as Dimensions?

300sss300 — Wed, 04 May 2016 05:36:44 GMT

Thanks !!!

Re: How to Combine 2 fields as Dimensions?

300sss300 — Wed, 04 May 2016 05:37:19 GMT

Thanks !!!