Baseline Expression

[#1]

How do you create a chart with two exprressions with one of them being a Total or Company trend with the second being a filtered dimention (ie store, state, etc)?

[#2]

Use SET ANALISYS

[#3]

ok, I'm new, what is SET ANALYSIS?

[#4]

Set Analysis is a means by which you can limit the data set you're performing analysis on using a special syntax. Assuming you're using Qlikview 9, the details can be found in the Qlikview Reference Manual in Book 3, page 353 (or page 1754 of the PDF).

i.e.

Sum({ $ < State={UT,AZ} > } sales)

Hope this helps.

-Alex

[#5]

Thanks for the tip! Works great!!