topic Re: set analysis expression in QlikView

set analysis expression

Thu, 27 Mar 2014 21:30:04 GMT

Hello all, I'm trying to calculate the total of gross bookings, based on some selections, but can't get it right. the expression I'm using is:

sum({<fiscal = {'$(vFiscal1)'}, [week no.] <= max({{$<fiscal = {'$(vFiscal2)'}>} [week no.]})>} [Gross_bookings])

I select fiscal year equals to vFiscal1, and [week no.] smaller than or equal to the maximum [week no.] available for vFiscal2.

Have been struggling with this for hours, can anybody help me iwith this?

Thanks!!

chiru_thota — Thu, 27 Mar 2014 21:35:29 GMT

I guess your syntax is wrong

Try to as below .Define a variable and test it fiest.Then use it in set analysis

vWeekno=max({{$<fiscal = {'$(vFiscal2)'}>} [week no.])

sum({<fiscal = {'$(vFiscal1)'}, [week no.] ={'<=$(=$(vWeekno))'}>} [Gross_bookings])

MK_QSL — Thu, 27 Mar 2014 21:48:25 GMT

SUM({$<fiscal = {'$(vFiscal1)'}, [week no.] = {"<=$(=Max({<fiscal = {'$(vFiscal2)'}>}[week no.]))"}>}Gross_bookings)

Thu, 27 Mar 2014 22:22:10 GMT

Thanks Chiranjeevi, very helpful

Thu, 27 Mar 2014 22:22:32 GMT

It worked! Thanks very much Manish