Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

stabben23
Honored Contributor

Pivot, dimension as column

Hi, Is it possible to avoid some (Produced, KG) of the expression to be repeted over the dimension BoM?

See example in Pic2. Set analysis on each BoM is not an solution here. Geniric Load, yes maybe, but is there any other ways?

Pic1:

Pic2:

Tags (2)
7 Replies
MVP
MVP

Re: Pivot, dimension as column

I am afraid that I do not understand your explanation or your example. Perhaps you should upload your qvw file and indicate exactly and specifically what is wrong, and what you are expecting.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MVP
MVP

Re: Pivot, dimension as column

Hi,

Click on the dimension and drag to the top of the measure columns, you can notice the the Red borders highlighted and drop where you want.

Regards,

jagan.

stabben23
Honored Contributor

Re: Pivot, dimension as column

Hi Jonathan,

can not upload qvw, I try again, If you drag and drop a dimension, in this case Region,  you will have all expression (Sales,Orders) over this dimension. If i just want to see Orders in all Region, what to do?

stabben23
Honored Contributor

Re: Pivot, dimension as column

Hi, the dimension BoM is draged and droped as a dimension on top of the Expression.

MVP
MVP

Re: Pivot, dimension as column

Hi,

Check this link in youtube and check 6th and 7th minute.

QlikView | Pivot Tables - YouTube

MVP
MVP

Re: Pivot, dimension as column

Just remove Region as a dimension? Or use partial totals on the pivot to see the expressions for all regions in the total column.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
stabben23
Honored Contributor

Re: Pivot, dimension as column

I  think I explain bad. lets say you have 3 expression, then drag and drop a dimension on top of the expression. Then you will have all 3 expression for every single field in the draged and droped dimension. Now the problem, you dont want to show 2 of you expression over the dimension, just 1 value, like below.  200871 is an ingoing item in Item 200894,200895,200896, is this understandable?

Community Browser