Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Dates/Months Missing

Hi All ,

I have data in the below format .

   

IDdate(dd-mm-yyyy)type
id101-01-2017A
id201-02-2017A
id301-03-2017B
id401-04-2017B

Now i want to display the count of IDs for the month of March and April for Type='A'

and Count of IDs  for the month of Jan and Feb for Type='B' .

i have master calendar generated linked to this date.

When i am filtering type=A in set analysis,the other dates are missing .

So how to get those Months .I would like to display data monthwise .

Can someone help on this .

Thanks,

Veera

1 Solution

Accepted Solutions
Highlighted

Re: Dates/Months Missing

May be like this

Count({<type = {A}>}ID) + Avg({1} 0)

Make sure to uncheck 'Suppress Zero Values' on the presentation tab of the chart properties

View solution in original post

3 Replies
Highlighted

Re: Dates/Months Missing

May be like this

Count({<type = {A}>}ID) + Avg({1} 0)

Make sure to uncheck 'Suppress Zero Values' on the presentation tab of the chart properties

View solution in original post

Highlighted
Creator II
Creator II

Re: Dates/Months Missing

Hi Sunny,

Great.That worked. Thanks you so much for the easy solution .

i did in this way as below .

Table:

load *,Date&Type as Existskey;

Load ID,Date,Type from table ;

concatenate(Table)

load * where not exists(Existskey,Date&Type ) ; 

load Date,'A' as Type resident mastercalendar ;

Above resident will laod all dates where Type=A is not present .

same i did for Type=B.

Will there be any performance lag if we do it this way at script level .

I tried using sum(0) instead of Avg(0) .that also worked.

Highlighted

Re: Dates/Months Missing

Depends on what you want... if you are getting the result without script manipulation, then why do it? But if you feel more comfortable that you have all data points for all types (and there are not too many of them), then you can go ahead with it.