Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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')
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