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.
