Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
I have a pivot table like this one:
TEC | Tec1 | Tec2 | Tec3 | |
REASON | ||||
Reason1 | 1 | 6 | 11 | |
Reason2 | 2 | 7 | 12 | |
Reason3 | 3 | 8 | 13 | |
Reason4 | 4 | 9 | 14 | |
Reason5 | 5 | 10 | 15 |
and I would like to obtaine a pivot table like this second one:
TEC | Tec1 | Tec2 | Tec3 | |
REASON | ||||
Reason1 | 1 (1%) | 6 (6%) | 11 (11%) | |
Reason2 | 2 (2%) | 7 (7%) | 12 (12%) | |
Reason3 | 3 (3%) | 8 (8%) | 13 (13%) | |
Reason4 | 4 (4%) | 9 (9%) | 14 (14%) | |
Reason5 | 5 (5%) | 10 (10%) | 15 (15%) |
The numbers in the table are arbitrary not real
In my app I have two dimension: REASON and TEC
and the expression COUNT(Order_Number)
Could you suggest me a solution. I'm new in QlikView and I still have so much to learn!
Thanks in advence
Regards
I try this expression without the dimension reason for every distinct reason:
=round(Count({<Cancellation_Order_Reason_Detail={'CAUSA DI FORZA MAGGIORE'}>}Cancellation_Order_Reason_Detail)/Count({<Macro_Tec-={'LTE'}>}Order_Number),0.01)*100&'% ('&Count({<Macro_Tec-={'LTE'}>}Order_Number)&')'
It works, but in this way I lost the dynamic list of reason dimension. So I can't use this solution!
Can you suggest a solution without losing the dynamism of the REASON dimension list?
Thanks