Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
soha1902
Creator
Creator

Add dimensions

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.

2 Replies
singhpooja
Creator III
Creator III

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,

soha1902
Creator
Creator

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

Please read my question properly.