Hello, I am new to qlik
I have this structure in my pivot table:
2.B - OFFICES
2.B.5 - NUMBER OF OFFICES
NO. OF OFFICES
2.C - BUSINESS MODEL
2.C.7 - PERCENTAGE OF BUSINESS MODEL
- PRIVATE BAND
- OTHER
2.C.8 - N PEOPLE DEPARTMENT
-N PEOPLE IN THE DEPARTMENT
2.D - CUSTOMERS
2.D.9 - Nº CUSTOMERS
- NATURAL PERSONS
-OFFICES
-OTHER
2.D.10 - PERCENTAGE OF CUSTOMER TRANSACTIONS
-PERCENTAGE OF CUSTOMERS
2.E - DEMAND ACCOUNTS
2.E.11 - AVERAGE DEMAND ACCOUNTS
-SIGHT
IS REPRESENTED:
- DIMENSION: REPORT --> GROUP --> SUBGROUP --> COD_DSC
- COLUMN: ENTITY (CLV_ENT)
- DIMENSION: VALUE (= SUM(IMP_VALUE))
what i want is to make an expression in which measure VALUE contains these causidics:
if it contains the word 'PERCENTAGE' then the calculation of %(IMP_VALUE) is done with format '#,##0.00%',
if it contains the word 'AVERAGE' then avg(IMP_VALUE) is calculated with format '#,##0.00',
and if it does not contain either of these two words you do sum(IMP_VALUE) with format '#,##0.00'.
so that when you activate the option to show the total of the entity (CLV_ENT) it reflects the corresponding data.
