
Re: Sort ZA in a partial sum field and exclude one value from a formula
arjun rao Sep 13, 2018 9:34 PM (in response to Josh Mcdermott)Can you attach the sample file?

Re: Sort ZA in a partial sum field and exclude one value from a formula
Josh Mcdermott Sep 14, 2018 2:05 PM (in response to arjun rao)How do I attach file?


Re: Sort ZA in a partial sum field and exclude one value from a formula
SARAT CHANDRA KAKUMANU Sep 16, 2018 10:00 AM (in response to Josh Mcdermott)Hi Josh,
U can attach a file by going to Use advance editor option on the right corner > then Attach on the bottom right on your next screen.
1. And coming to your question in a pivot table you can sort and do a sum only based on a Dimension and not based on any expression so if you need to sort and sum based on any other column Straight table is a better option. Please find the sample Tutorial Final Qlikview document. Refer Geography sheet > Pivot and Straight table. Also, refer below link for the differences.
https://community.qlikview.com/thread/80815
2. You can do this by adding a new expression and in the expression using the names given as the expression names. Please see attached for the Difference field in which I have subtracted the earlier expressions.
Hope I have helped answer your question. If not please give a sample Qlikview document.
Thanks,
Sarat.K

TutorialFinal.qvw 611.2 K


Re: Sort ZA in a partial sum field and exclude one value from a formula
Josh Mcdermott Sep 19, 2018 9:03 AM (in response to Josh Mcdermott)This is all I could figure out how to attach "Use advance editor option on the right corner" I can't find on my screen. I tried a straight table, and I definitely need to be using the pivot. I got it to sort by adding "posted bal" as the first column, but I want that dimension hidden, can I do that?

Re: Sort ZA in a partial sum field and exclude one value from a formula
Josh Mcdermott Sep 19, 2018 9:29 AM (in response to Josh Mcdermott)I uploaded excel file under New to Qliksense, and
Sort ZA in a partial sum field and exclude one value from a formula
is the title. The file is called Sample File.xls