topic Re: Set analysis help in QlikView

Set analysis help

Anonymous — Mon, 27 Apr 2015 06:42:30 GMT

HI i need help on set analysis in the below expression.

Sum({$<Year={$(=max(Year))},MTDYTD = {'MTD'},HR_MONTH ={$(=max(HR_MONTH))},HR_Month1=>} HR01_ACTIVEEMPLOYEE + HR01_TEMPRYEMPLOYEE*Emp_Value).

For HR_MONTH i want to write

HR_MONTH Betwen 1 and MAX(HR_MONTH)

Thanks

Re: Set analysis help

robert_mika — Mon, 27 Apr 2015 06:46:42 GMT

Duplicate:

set expression help

Re: Set analysis help

Mon, 27 Apr 2015 06:49:51 GMT

Please provide the specific scenario to get the exact result for above issue

thanks

Re: Set analysis help

Anonymous — Mon, 27 Apr 2015 06:58:36 GMT

thanks for the reply !!

i need hr_month should get data only betweeen 1 and max(hr_month)

Thanks

Re: Set analysis help

vvvvvvizard — Mon, 27 Apr 2015 07:03:50 GMT

hr_month = {'>= 1 < $(=max(hr_month))'}

hr_month = {'>= 1 < $(=max(num(hr_month)))'}

Re: Set analysis help

nirav_bhimani — Mon, 27 Apr 2015 07:04:07 GMT

try this condition in your current one

HR_MONTH ={">=$(=min(HR_MONTH))<=$(=max(HR_MONTH))"}

Regards,

Nirav Bhimani

Re: Set analysis help

Mon, 27 Apr 2015 07:12:27 GMT

Sum({$<Year = {$(=max(Year))}, MTDYTD = {'MTD'}, HR_MONTH = {$(=max(HR_MONTH))},

HR_Month1 = {">=1<= max(HR_MONTH)"}>} HR01_ACTIVEEMPLOYEE + HR01_TEMPRYEMPLOYEE*Emp_Value)

Re: Set analysis help

Mon, 27 Apr 2015 07:58:13 GMT

Hi rgv,

can HR_MONTH actually be less than 1? From the sound of it I would think not so all you would need is a less than/equal to max. Keeps the expression simpler

HR_MONTH ={"<=$(=max(HR_MONTH))"}

hope that helps

Joe