Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
vireshkolagimat
Contributor III

show only total in Pivot table

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

Count of stores.PNG

5 Replies
NhanNguyen
New Contributor III

Re: show only total in Pivot table

Have you tried to use set analysis? 

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

Partner
Partner

Re: show only total in Pivot table

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
vireshkolagimat
Contributor III

Re: show only total in Pivot table

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
vireshkolagimat
Contributor III

Re: show only total in Pivot table

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

Partner
Partner

Re: show only total in Pivot table

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