topic Re: Add dimensions in QlikView

Add dimensions

soha1902 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I want to add all the dimension in Pivot/Straight table dynamically. For example I have following 2 dimensions(PID and Product) in the load statement:

Load * inline [

PID, Product, Amount

1,Product1,100

2,Product2,200

]

But in later stage I'll add more dimension in the script or I'll use load *. Now In UI, how we will add all the loaded dimension automatically.

Is there any way to do this.(I dont want to add dimension manually bcz in my data, dimension were change frequently )

Please share your comments on it.

Re: Add dimensions

Anonymous — Thu, 24 Nov 2016 07:18:18 GMT

Hi Soha,

Apply in following way:

TableX:

Load * inline [

PID, Product, Amount

1,Product1,100

2,Product2,200

];

TableY:

load * ,

'Test1',

'test2'

Resident TableX;

drop Table TableX;

It will add two more dimensions like test1 and test2

Thanks,

Re: Add dimensions

soha1902 — Thu, 24 Nov 2016 07:23:18 GMT

I want to add dimension name dynamically in Pivot or Straight Table. I am using Load * from Table name.

Please read my question properly.