Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vireshkolagimat
Creator III
Creator 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
Contributor III
Contributor III

Have you tried to use set analysis? 

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

uacg0009
Partner - Specialist
Partner - Specialist

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
Creator III
Creator III
Author

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
Creator III
Creator III
Author

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

uacg0009
Partner - Specialist
Partner - Specialist

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