Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic field in simple table

Hi All,

I would like to create a table with one dynamic field :

I have measures :

unit quantity

sales

margin

And dimensions :

product

country

customer

The tableau should appear like this :

productunit qtsalesmargin
Shoes12$12324$123
Book21$23456$321
Chairs32$3454$234

and I would like to click on something to switch the dimension to another :

countryunit qtsalesmargin
USA12$12324$123
UK21$23456$321
China32$3454$234

The "thing" to click could be a filter or or a selector.

Also be able to dynamically add a dimension like this :

countrycustomerM1M2M3
USAJack3$123$12
USAMike4$345$23
UKPaul5$23456$321
UKBill3$234$43
ChinaPatrick2$3454$234
ChinaSimon1$234$54

I could use a Pivot table but I want my users to dynamically add and remove whatever the dimensions they want.

Anyone has an idea ?

Thank you,

C.

4 Replies
sunny_talwar

You can use Inline table with your dimension name to drive your dimensions. Do you have a sample which we can piggy back on to demonstrate how this can be done?

Not applicable
Author

Please find attached sample test for those dynamics field.

Tahnk you,

C.

Anonymous
Not applicable
Author

brunobertels
Master
Master

Hi Cyrille

may be try this solution :

Using variable

download qsvariable in qlikbranch site

add variable object named it as vDim for example and create 3 buttons called

product country customer as name and add as value your dimensions

See example app attached and reproduced it accordind to your data and second sheet of your own app attached

Hope it helps

Bruno