Dynamic field in simple table

[#1]

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 :

product	unit qt	sales	margin
Shoes	12	$12324	$123
Book	21	$23456	$321
Chairs	32	$3454	$234

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

country	unit qt	sales	margin
USA	12	$12324	$123
UK	21	$23456	$321
China	32	$3454	$234

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

Also be able to dynamically add a dimension like this :

country	customer	M1	M2	M3
USA	Jack	3	$123	$12
USA	Mike	4	$345	$23
UK	Paul	5	$23456	$321
UK	Bill	3	$234	$43
China	Patrick	2	$3454	$234
China	Simon	1	$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.

[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?

[#3]

Please find attached sample test for those dynamics field.

Tahnk you,

C.

[Anonymous]

Why not go for adhoc report?

Adhoc reporting in Qlikview

Ad-Hoc Reporting in Qlikview

[brunobertels]

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