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: 
oseimuduame
Creator II
Creator II

Total Summing of Sales Dashboard

Good afternoon,

i have a dashboard that i need little help on;

i have 7 stores in my dashboard and i want to display their sales separately but the sum is not summing up in the Straight table but when i filter the store it sum it up correctly.

i used this Expression if(Store_no = 1, sum(invoice_price))

i need help please. What can i do to get each straight table to sum my sales up correctly.

thank you.

7 Replies
Gysbert_Wassenaar

Do all the seven stores have the same Store_no? If not then replace the if statement with sum(invoice_price) because the if statement will only sum the results for the stores with Store_no 1.


talk is cheap, supply exceeds demand
Anil_Babu_Samineni

Would you share the Script. How you are loaded the 7 tables. And share screen shot which demonstrates the O/P

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
oseimuduame
Creator II
Creator II
Author

No, all store have different store no.

E.g for Store 1 = if(store_no = 1, sum(invoice_price)

store 2 = if(store_no = 2, sum(invoice_price) for all store till in different chart so i used 7 charts

but where i am to have total sales of each store i am not getting a sum up total sales....

Gysbert_Wassenaar

Try expressions like this:

store 1: sum({<store_no={1}>}invoice_price)

store 2: sum({<store_no={2}>}invoice_price)

store 3: sum({<store_no={3}>}invoice_price)

store 4: sum({<store_no={4}>}invoice_price)

store 5: sum({<store_no={5}>}invoice_price)

store 6: sum({<store_no={6}>}invoice_price)

store 7: sum({<store_no={7}>}invoice_price)

total: sum({<store_no={1,2,3,4,5,6,7}>}invoice_price)


talk is cheap, supply exceeds demand
oseimuduame
Creator II
Creator II
Author

dashboard.png

Thats the screenshot.

Gysbert_Wassenaar

The if statement can't be evaluated at the total level so you don't get a total. Use the expressions I posted or set the Total mode of the expression to Sum of Rows.


talk is cheap, supply exceeds demand
oseimuduame
Creator II
Creator II
Author

the expression is working perfectly thank you.

sum({<STORE_NO={1}>}INVC_EXT_PRICE)

Thank You