- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to add different calculations for different values in a particular column.
Hello Everyone,
I am bandari, i have just started working with qliksense. i am currently working and i am stuck somewhere and i am not finding any answer for it.
I have 13 columns like P01,P02..P12, and KPI column. for example:
KPI | q1 | q2 | q3 | q4 |
A | P03 | P06 | P09 | P12 |
B | P01+P02+P03 | P04+P05+P06 | P07+P08+P09 | P10+P11+P12 |
C | P03 | P06 | P09 | P12 |
Now i will have to calculate values for every quater(q1,q2,q3,q4) depending on each Kpi value(i.e., if its 'A' then i have just give the sum of P03 for q2, If its 'B' then it should be sum(P01+P02+P03) for q1 likewise i have to calculate P06 for q2 and sometimes P01+P02+P03 for q2). i have importe the script . but now i dont know how to proceed furthure. Please help me do this. I have a deadline by this saturday. Please give sample querys if possible.
Thank you so muh for your time .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello , I have tired doing it with range sum function but it is just letting me to give one expression for one variable. is it possible to give two expressions for one variable and calculating according to the other column values in qliksense.