topic Set analysis Issuse in QlikView

Set analysis Issuse

Anonymous — Tue, 31 Mar 2015 07:19:35 GMT

Hi,

i usesd set analysis concept for getting of max date and previous date.It works good but when i select the date field,month field the sum of previous date related data shows 0.

Please help me

Please find following attachemnts for reference.

Thanks,

Re: Set analysis Issuse

pokassov — Tue, 31 Mar 2015 07:43:38 GMT

Hi!

Try this:

=if(MTD='Day','Prev''s Day: ' & num(sum({$<Day=,Month=,Date={'$(=v_previous_date)'},[Key Indicaters]={'Total Call Vol @ Call Center'}>} Key_Data),'#,###')

,'Prev''s Month: ' & num(sum({$<Day=,Month=,Month={'$(=v_prev_month)'},[Key Indicaters]={'Total Call Vol @ Call Center'}>} Key_Data),'###,###')

)

With out deleting Day and Month you are looking in overlaping day,month (28 and feb) and previos day (27 feb).

this overlaping is zero.

Re: Set analysis Issuse

ladislav — Tue, 31 Mar 2015 08:09:50 GMT

Hi.

Your only issue is that there is no data meeting condition for Jan/28/2015. That's why you get 0. There is no such entry in your table. If you deselect the date you get result. Otherwise fill your table with Jan/28/2015 Key_Data.
Look on picture.

Ladislav

Re: Set analysis Issuse

Anonymous — Wed, 01 Apr 2015 07:21:00 GMT

Hi cepren,

Thanks for your help its working fine.

Thanks,