Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
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
Partner

Hi dj,

check the attached sample....

View solution in original post

1 Reply
fosuzuki
Partner
Partner

Hi dj,

check the attached sample....

View solution in original post