topic Set Analysis Not working in QlikView

Set Analysis Not working

noman212 — Fri, 31 Oct 2014 10:55:39 GMT

hi Friends,

i have a speedo meter which display record on current day basis it was working fine in project but when i modified the project and add 1 field its shows 0 counts inspite of 251.

set analysis used in speedometer.

=Count ({<CalendarDate={'$(=max(CalendarDate))'} >} proposal)

Re: Set Analysis Not working

MK_QSL — Fri, 31 Oct 2014 10:59:30 GMT

May be because the Max(CalendarDate) have 0 data...

Try

Create a Straight Table with

Dimension

CalendarDate

Expression

COUNT(proposal)

Sort By CalendarDate descending order and go to presentation tab and untick suppress zero values..

let me know what is the value coming for max CalendarDate

If it is Zero, you can try below

=Count({<CalendarDate = {'$(=Date(Max(CalendarDate)-1))'}>}proposal)

Re: Set Analysis Not working

noman212 — Fri, 31 Oct 2014 11:19:54 GMT

Thanks alot for your solution , when i put Date before MAX in set expression its work fien but i dnt know why it happened...