topic Re: Total Sales Over $500k in QlikView

Total Sales Over $500k

win_anthony — Sat, 16 Nov 2024 19:21:30 GMT

The goal is to create a syntax that will only list the total sales for companies that are over $500k on a bar chart. I have been trying to get this to work but the output is simply not working.

Current Syntax which is NOT working:

= NUM( SUM( {$< [Pizza Stores Flag] = {'Yes'}, SUM([Sales]) > 500000 >} [Sales] ), '$#,##0')

Ex: List only companies with sales $500k > that sell PIZZA

- McDonalds = $1.2m

- Domino's Pizza = $2m

- Popeyes = $1m

- Pizza Hut = $200k

- Papa John's Pizza = $600k

Target Output:

- Domino's Pizza ($2m) + Papa John's Pizza ($600k) = $2.6m

I know the example might be archaic but I hope you can understand what I am trying to get at.

Re: Total Sales Over $500k

Kushal_Chawda — Sun, 05 Jan 2020 11:22:39 GMT

try something like below

NUM( SUM( {$< [Pizza Stores Flag] = {'Yes'},Company={"=SUM([Sales]) > 500000"} >} [Sales] ), '$#,##0') or NUM( SUM( {$<Company={"=SUM({<[Pizza Stores Flag] = {'Yes'}>}[Sales]) > 500000"} >} [Sales] ), '$#,##0')

Re: Total Sales Over $500k

Brett_Bleess — Mon, 06 Jan 2020 15:40:31 GMT

In addition to Kush's response, I wanted to give you another area to look for some posts that may be helpful:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Specifically, maybe the following:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

Hopefully those along with Kush's post will get you what you needed.

Regards,
Brett