topic Re: Set analysis and null/unknown in QlikView

Set analysis and null/unknown

robert_mika — Thu, 10 Dec 2015 06:04:03 GMT

I'm creating chart with counts.

My dimension is

DayofWeek(Mon,Tue....)

If the data set is clean no gaps I can manipulate the values after Today() in normal way

They will changed the chart values accordingly

If I got bigger data set (some of the row may have missing or null values ) the result stays almost the same with any of this configuration

=count({<CalendarDate= { "<=$(=Date(Today()-1, 'DD/MM/YYYY'))>$(=Date(Today()-20, 'DD/MM/YYYY'))"> }>} id)

=count({<CalendarDate= { "<=$(=Date(Today()-1, 'DD/MM/YYYY'))>$=(Date(Today()-100, 'DD/MM/YYYY'))"> }>} id)

=count({<CalendarDate= { "<=$(=Date(Today()-1, 'DD/MM/YYYY'))>$=(Date(Today() , 'DD/MM/YYYY'))"> }>} id)

Which is always the the values (whole data set)

After playing with the numbers I see that the second condition (greater) is not evaluated.

What I'm missing here?

tresB — Thu, 10 Dec 2015 06:43:13 GMT

))>$=(Date(Today()-100 , .. is it a typo? If not , try like: ))>$(=Date((Today()-100),

avinashelite — Thu, 10 Dec 2015 06:47:35 GMT

try like this :

count({<CalendarDate={">=$(=Date(Today()-100,'MM/DD/YYYY'))<=$(=Date(Today()-1,'MM/DD/YYYY'))"}>}id)

avinashelite — Thu, 10 Dec 2015 06:48:57 GMT

I feel the conditions are not properly ended...try with the above format

Kushal_Chawda — Thu, 10 Dec 2015 06:53:50 GMT

try this

count({<CalendarDate= { "<=$(=Date(Today()-1, 'DD/MM/YYYY'))>$(=Date(Today()-20, 'DD/MM/YYYY'))" }>} id)

=count({<CalendarDate= { "<=$(=Date(Today()-1, 'DD/MM/YYYY'))>$(=Date(Today()-100, 'DD/MM/YYYY'))" }>} id)

=count({<CalendarDate= { "<=$(=Date(Today()-1, 'DD/MM/YYYY'))>$(=Date(Today() , 'DD/MM/YYYY'))"}>} id)

robert_mika — Thu, 10 Dec 2015 07:16:45 GMT

Thank you all for input

The final solution is

=count({$<CalendarDate= { "<=$(=Date(Today()-10, 'DD/MM/YYYY'))>=$(=Date(Today()-20, 'DD/MM/YYYY'))" }>} id)

You were right - the equal sign

@Avinash R that did not work

that helps with the second >