Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Set analysis Issuse

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,

1 Solution

Accepted Solutions
Specialist
Specialist

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.

View solution in original post

3 Replies
Specialist
Specialist

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.

View solution in original post

Contributor III
Contributor III

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

Creator
Creator

Hi cepren,

Thanks for your help its working fine.

Thanks,