Set Analysis - applying filters to result set

Thu, 16 Feb 2012 19:19:23 GMT

Hi All,

I'm having trouble with my set analysis expression. I was able to get the following to work, which limits my data to the previous years' data for the selected date range.

Sum({1<TRADE_DATE_T = {'>=$(=num(AddYears(min({$} TRADE_DATE_T),-1))) <=$(=num(AddYears(max({$} TRADE_DATE_T),-1)))'}>} [TOTAL])

Now I need it to be limited by the user filter SECTOR as well. I tried something like this, but it didn't work

Sum({1<SECTOR = P({1<TRADE_DATE_T = {'>=$(=num(AddYears(min({$} TRADE_DATE_T),-1))) <=$(=num(AddYears(max({$} TRADE_DATE_T),-1)))'}>} SECTOR), SECTOR = {$(=Only(SECTOR))}>} [TOTAL])

Thanks,

Victor

Set Analysis - applying filters to result set

deepakk — Thu, 16 Feb 2012 21:45:29 GMT

Can you attach some sample data. To solve such kind of a problem we need to understand the flow of data.

Deepak

topic Set Analysis - applying filters to result set in QlikView

Set Analysis - applying filters to result set

Set Analysis - applying filters to result set