Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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