topic Re: show only total in Pivot table in QlikView

show only total in Pivot table

vireshkolagimat — Mon, 24 Dec 2018 10:16:09 GMT

Dear All,

I've a pivot table and it gives the sales by supplier and by store like the image attached.

I can show the total sales by both store and by supplier. How to show the count of stores where the sales value is zero.

Regards,

Viresh

Re: show only total in Pivot table

NhanNguyen — Tue, 25 Dec 2018 07:23:22 GMT

Have you tried to use set analysis?

Maybe something like this: Aggr(Count(<{Value=0}>),Supplier)

Re: show only total in Pivot table

uacg0009 — Wed, 26 Dec 2018 06:04:21 GMT

Hi, Vireshkolagimat,
I think it's hard to add a expression next to your "total sales", but the table can be done by straight, there is a question, the number of your "store" is fixed or not? only 4 store?
if yes, I think you can hard-code it in straight table to make it.
Aiolos

Re: show only total in Pivot table

vireshkolagimat — Wed, 26 Dec 2018 08:17:14 GMT

Hi, Kindly find the attached sample file. For each store i have two expressions ie sum(sales) and count(store). My requirement is instead of repeating the count metric for each store, is it possible to store the only grand total at the right side of the table. Thank you. Regards, Viresh

Re: show only total in Pivot table

vireshkolagimat — Wed, 26 Dec 2018 08:18:35 GMT

Hi, The stores will vary but i need the expression as part of the pivot table. Thanks

Re: show only total in Pivot table

uacg0009 — Wed, 26 Dec 2018 09:10:30 GMT

Hi,
I found a way to make it in back-ground script, is that ok for you?
You can create a table like what you want in back-end.
Then use it in front-end.
Aiolos