Set Analysis

Mon, 22 Feb 2010 21:40:11 GMT

I have to expressions that are working independently, but I would like to combine them into one. How would I do that?

Expression 1:

Brings back only XYZ Brand based on other dynamic selections:

sum({<[Brand]={"XYZ"}>}TotalGSV)

Brings back YTD results:

sum({$<Year = {$(=only(Year))}, Month = {"<=$(=max(Month))"}>} TotalGSV)

I am trying to combine these because I want to bring back a specific brand all of the time but want the values to change based on my year to date selection.

Any suggestions??

Set Analysis

johnw — Mon, 22 Feb 2010 21:48:43 GMT

sum({<Brand={'XYZ'},Year={'$(=only(Year))'},Month={"<=$(=max(Month))"}>} TotalGSV)

Or am I not understanding?

Set Analysis

Mon, 22 Feb 2010 22:21:01 GMT

Thank you! That worked!!

topic Set Analysis in QlikView

Set Analysis

Set Analysis

Set Analysis