Pivoting for Diff Expressions

[#1]

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.

[qlikpahadi07]

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