topic Re: Load dimension in particular order in QlikView

Load dimension in particular order

bharatkishore — Tue, 13 Sep 2016 10:22:00 GMT

Hi All,

I have a dimension called channel and in that i have fields like a,b,c,d,e.. Now i want to load in particular order like.

e,b,c,a,d..

Can you please tell me how can i achieve it.

Thanks,

Bharat

Re: Load dimension in particular order

kaushiknsolanki — Tue, 13 Sep 2016 10:24:13 GMT

Hi,

When you say load, do you mean while showing on frontend it should be shown in defined order?

if yes then you can use the Expression option under sorting tab.

The expression will be like this.

If(Value = 'e',1,

If(Value = 'b',2,

If(Value = 'c,3,

If(Value = 'a',4,

If(Value = 'd',5,....

Regards,

Kaushik Solanki

Re: Load dimension in particular order

effinty2112 — Tue, 13 Sep 2016 10:27:54 GMT

Hi Bharat,

Try something like:

Temp:

Load

Channel,

Match(Channel,'e','b','c','a','d',..) as LoadOrder,

;

Data:

Load

Channel, //exclude LoadOrder field or else load * withNoConcatenate

Resident Temp Order by LoadOrder;

Drop Table Temp;

Cheers

Andrew

Re: Load dimension in particular order

bharatkishore — Tue, 13 Sep 2016 10:31:12 GMT

Thanks a lot...Slight confusion..

Re: Load dimension in particular order

bharatkishore — Tue, 13 Sep 2016 10:31:36 GMT

Thanks a lot Andrew..

Re: Load dimension in particular order

kaushiknsolanki — Tue, 13 Sep 2016 10:32:37 GMT

Yes Please tell me whats the confusion.

Re: Load dimension in particular order

bharatkishore — Tue, 13 Sep 2016 10:38:50 GMT

No.. i m saying that i am bit confused because i have done this but i forget...

Re: Load dimension in particular order

kaushiknsolanki — Tue, 13 Sep 2016 10:39:49 GMT

Okies.

Cheers..

Regards,

Kaushik Solanki

Re: Load dimension in particular order

its_anandrjs — Tue, 13 Sep 2016 11:18:39 GMT

Thanks Andrew,

What if when there is 120 values in single field and required to load in the proper order.

Regards,

Anand

Re: Load dimension in particular order

effinty2112 — Tue, 13 Sep 2016 12:12:05 GMT

Hi Anand,

If the load order was defined in a separate table of 120 values in the order we want we can load this first table with an autonumber field. The fact table can then be loaded as a temp table with an autonumber field on this dimension and then the facts can be loaded from this temp resident table ordered by that autonumber field.

Cheers

Andrew