topic Re: How to use function in Set Analysis in QlikView

How to use function in Set Analysis

kamal_sanguri — Thu, 13 Aug 2015 12:52:29 GMT

I want to replace {'201504'} with max(PERIOD), Any Idea on this

=if(GetSelectedCount(PERIOD)=0,sum({<PERIOD={'201504'}>}BUD_DOLLARS_CY),sum(BUD_DOLLARS_CY))

Re: How to use function in Set Analysis

MK_QSL — Thu, 13 Aug 2015 12:53:25 GMT

=if(GetSelectedCount(PERIOD)=0,

sum({<PERIOD={'$(=Max(PERIOD))'}>}BUD_DOLLARS_CY),

sum(BUD_DOLLARS_CY))

=if(GetSelectedCount(PERIOD)=0,

sum({<PERIOD={'$(=Date(MonthStart(AddMonths(Date#(Today()),-4)),'YYYYMM'))'}>}BUD_DOLLARS_CY),

sum(BUD_DOLLARS_CY))

Re: How to use function in Set Analysis

maximiliano_vel — Thu, 13 Aug 2015 12:53:47 GMT

Try

=if(GetSelectedCount(PERIOD)=0,sum({<PERIOD={$(=Max(PERIOD))}>}BUD_DOLLARS_CY),sum(BUD_DOLLARS_CY))

Re: How to use function in Set Analysis

Thu, 13 Aug 2015 12:54:43 GMT

=if(GetSelectedCount(PERIOD)=0,sum({<PERIOD={"$(=max(PERIOD))"}>}BUD_DOLLARS_CY),sum(BUD_DOLLARS_CY))

Re: How to use function in Set Analysis

Gabriel — Thu, 13 Aug 2015 13:41:52 GMT

Hi,

To use any function inside Set Analysis you need = sign before the function

Re: How to use function in Set Analysis

kamal_sanguri — Fri, 14 Aug 2015 03:42:04 GMT

Thank you very much for your expertise, I have one more question.. Different people gave me different functions.. and all of them worked.. for ex: if I put the max funciont inside " " or ' ' or even if I just write function without any one of them all worked.. so what is the difference and which is a better/correct way.

Thanks again,

-Kamal

Re: How to use function in Set Analysis

kamal_sanguri — Fri, 14 Aug 2015 03:42:17 GMT

Thanks

Re: How to use function in Set Analysis

kamal_sanguri — Fri, 14 Aug 2015 03:42:35 GMT

Thanks