dimension in pivot one below the other - Qlik Community

Report Inappropriate Content · ‎2015-03-18

Hi I have a question,

is it possible to put the Dimension in a Pivot one below the ozher instead of side by side??

Thanx

PrashantSangle · ‎2015-03-18

NO...

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2015-03-18

ok and with a lot of hours with new tables and so on???

hariprasadqv · ‎2015-03-18

Pivot allows reorganizing the position of the fields from horizontal to vertical and verticle to horizontal just by drag and dropping into Appropriate position.

PrashantSangle · ‎2015-03-18

Hi,

I am sorry but i did not understand your requirement.

Can you elaborate?

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2015-03-18

i try

normal abroach

Dim1 Dim2 Dim3

Dim2 Dim3

Dim3

in all Dimension are values and i have a sum

so my Task is to bring it dim one below another

my example

value

Dim1sum

value

Dim2sum

value

Dim3sum

tresesco · ‎2015-03-18

You might try with Indent mode (Style tab) of the chart and proper alignment. Check the attached sample.

Report Inappropriate Content · ‎2015-03-18

thanx for your answer but i dont want teh dim colums side by side only in one column...

buzzy996 · ‎2015-03-18

I think so u can do it, drag dimension column as row in pivot table and see,tht's what ur expecting the result or not.

the data some thing like this,

Dim proda prodb

Dim2 proda1 proda2 exp1 prodb1 prodb2 exp1