Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Move expression value from "TOTAL" line from multiple sheets to a summary sheet

Hi Experts,

Somehow , I can't figure this out, Need help.

I have multiple sheets in my qlikview report.  What I am trying is, to move a value from "Total" row (expression value)  from multiple sheets into a consolidated summary sheet and plot a pie chart. I am having issues doing this,

1) In the attached spreadsheet,for sheet "DATE" , the expression I am using is ( = SUM(B)]/sum(total <Date> A) ), i.e calculate error for each DATE .  Expression is working at each row , but at TOTAL row, it is showing error as "0" . I was hoping it applies the same expression at total line as well (although, not sure what DATE it would consider at TOTAL line level. not sure if this is where it is going wrong ?)  but it is not the case.

2) In the second sheet "Item", it is the same issue where  at each line level , the expresssion is working but at the TOTAL line level, it shows  expression gvalue = "0". The expression =SUM(B)/sum(total <BaseItem> A) ( Each base item can have multiple items, so calculating error at each baseitem level).

3)  Move the "Error" from TOTAL, from both the sheets into a seperate summary sheet and plot a pie chart.

Greatly appreciate your help.

Thanks in advance ...SV

0 Replies