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!
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