Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In My Requirement are pivot table ,columnwise running total need.
i tried before function is not get correct result
if(Week=1,Column(1),Column(1)+Before(Column(3)))
kindly refer attached excel file
Thanks,
Muni
Hi , anybody know the answer ,kindly help to me.
Hi,
do you really need pivot table?
How many dimensions do you have in this chart?
regards
Darek
Hi Darek,
I need pivot table only.based on client requirement.
now i used only one dimension (week) for this chart.
Mathew,
You may define island table with 2 fields: expressionLabel, number.
Define 1 row for each normal expression from your pivot + one additiinal
for this total accumulation A.
Then in pivot:
- use expression label as additional dimension
- use pick(number, expr1, expr2...) as expression.
I will try to find example later, If you need.
Anyway, this is much easier in straight table...
Regards
Darek
14-05-2014 06:11 użytkownik "Mathew Munish" <qcwebmaster@qlik.com>
napisał:
Qlik Community <http://community.qlik.com/> Pivot Table Column
wise Running Total
reply from Mathew Munish<http://community.qlik.com/people/muniyandi?et=watches.email.thread>in *App
Development* - View the full discussion<http://community.qlik.com/message/527822?et=watches.email.thread#527822>