Pivoting for Diff Expressions

Sat, 28 Sep 2013 12:23:21 GMT

Hello sir,

I am using Qlikview 11.

I have Column as Valuetype contains { BUQ,RUQ,VALUE }.

Now i want to pivot this column on expressions.but under BUQ {BUM , BUM 0-30 , BUM 31-60 } exp should display

and under RUQ {RUM, RUM0-30 , RUM31-60 } exp should display and under VALUE {VALUE 0-30, VALUE 31-60 ,VALUE }.

The Sructure will be like this.

BUQ | RUQ | VALUE

----------------------------------------------------------|---------------------------------------------------------------|----------------------------------------

BUM 0-30 BUM 31-60 BUM61-90 | BUM 0-30 BUM 31-60 BUM61-90 | VALUE0-30 VALUE31-60

| |

Any Suggestions.

THANK U.

Re: Pivoting for Diff Expressions

qlikpahadi07 — Mon, 30 Sep 2013 10:13:39 GMT

I am not Sure you are aware of PIVOTING concept if not you try that one.

you need to drag your column Valuetype to right top when a Blue Arrow will be shown up.

else you attach a Sample data that can be helpful

topic Re: Pivoting for Diff Expressions in QlikView

Pivoting for Diff Expressions

Re: Pivoting for Diff Expressions