Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Valued Contributor II

Re: Missing dataset for calculating rate

Hi dj,

check the attached sample....

1 Reply
fosuzuki
Valued Contributor II

Re: Missing dataset for calculating rate

Hi dj,

check the attached sample....