How to Show data into Single Table when multiple rows getting generated by Model

Fri, 09 Jun 2017 10:30:06 GMT

Hi ALL ,

I have just started working on my first dashboard :

Background :

I have Three Agg Tables with different granularity

Table 1:

Column (DIM) : A,B ,C,D, E,F,G,H

Measure :M1

Table 2:

A,B,M3,M4,M5

Table 3:

A,B ,C,M6,M7,M8

I had synthetic key generation so to solve it I did following:

Table 1:

A|B|C|D|E as Tab_1_Key;

A|B as Tab_2_Key

A|B|C as Tab 3_Key

Table 2:

A|B|C|NULL|NULL as Tab_1_Key;

A|B as Tab_2_Key

A|B|NULL as Tab 3_Key

M3,M4,M5

Table 3:

A|B|C|NULL|NULL as Tab_1_Key;

A|B as Tab_2_Key

A|B|C as Tab 3_Key

M6,M7,M8

LINK :

Tab_1_Key,Tab_2_Key,Tab 3_Key,D, E,F,G,H From Table 1

Concat

Tab_1_Key,Tab_2_Key,Tab 3_Key,A,B from Table 2

Concat

Tab_1_Key,Tab_2_Key,Tab 3_Key,A,B,C from Table 3

This Solved My Issue of Key and I have perfect Link table created .

Issue : I am trying to give users Report where by clicking box they can select Dim and Measure in Chart Table so based on selection Table will form automatically .

Issue is that whenever I select D,E,F column with other measures from Table 2 ; There are two rows coming One with NULL as D and other with actual value . Same goes for E and F . I understand this is because of the Tab_1_Key formed at Table 2 .

I need help to display only one row in Chart table , can someone please guide how to get this .

topic How to Show data into Single Table when multiple rows getting generated by Model in QlikView

How to Show data into Single Table when multiple rows getting generated by Model