topic Re: Set analysis explanations in QlikView

Set analysis explanations

Thu, 28 Nov 2013 07:49:10 GMT

Hi guys,

I need some clues about set analysis. Something i must have forgotten

this is the result of a year and 2 months selection using set analysis

Sum ({<Dte.YearMonth={$(=max(Dte.YearMonth))}>} Rev.[Amount])

according to this model

2. I'd like to understand I can't use this

Sum ({<Dte.YearMonth={$(<=max(Dte.YearMonth))}>} [Rev.Amount]) (note <=) to have a YTD result with 1 year and 1 month selected?

The following set works with RevYear and Rev.month

sum ({<[Rev.Year]={'$(vMaxYear)'}, [Rev.Month]={'<=$(vMaxMonthNum)'}, Dte.Year=, Dte.Month=>} [Rev..Amount])

But why not with Dte.Year and Dte.month

Thnak you

Chris

dirk_konings — Thu, 28 Nov 2013 15:20:14 GMT

try this one :

Sum ({<Dte.YearMonth={'<=$(=max(Dte.YearMonth))'}>} [Rev.Amount])

Dirk

Clever_Anjos — Thu, 28 Nov 2013 15:36:26 GMT

You´re misplacing the <=

The correct would be

Sum ({<Dte.YearMonth={<=$(=max(Dte.YearMonth))}>} [Rev.Amount])

Clever_Anjos — Thu, 28 Nov 2013 15:37:22 GMT

Be careful that Max() return a not formatted number, so you should format it too

Sum ({<Dte.YearMonth={<=$(=date(max(Dte.YearMonth),'MM/DD/YYYY'))}>} [Rev.Amount])

Fri, 29 Nov 2013 10:34:28 GMT

Hi Guys

thank you for your answers.

Jus a metter of a very little '=' sign

have a nice day

Chris