Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Missing dataset for calculating rate

Hello QVer,

I'm loading DATE/DEP fields. For some DATE/DEP I get no datasets (rows) via ODBC.

This looks like:

DATE
DEP
VALUE

01.01.2012

A1
01.01.2012A1
02.01.2012A4
02.01.2012B3

Count(DATE|A)=3

Count(DATE|B)=1 -> should be 2 but 01.01.2012|B is missing.

For calculating whole selected periods (i.e. week, month, year) with all days I need also DATE rows per DEP not originally comming via ODBC.

It should look like:

DATE
DEP
VALUE
01.01.2012A1
01.01.2012A1
02.01.2012A4
01.01.2012B-
02.01.2012B3

...ASO

In other words I need additional DATE|DEP sets for calculating a rate.

Should be done in QV script.

Tried a lot. How to solve that? Thanks. Regards.

dj_skbs

1 Solution

Accepted Solutions
fosuzuki
Partner - Specialist III
Partner - Specialist III

Hi dj,

check the attached sample....

View solution in original post

1 Reply
fosuzuki
Partner - Specialist III
Partner - Specialist III

Hi dj,

check the attached sample....