topic How to retain table structure even if values corresponding to dimension are not there ? in QlikView

How to retain table structure even if values corresponding to dimension are not there ?

shekhar_analyti — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

How to retain table structure even if values corresponding to dimension are not there ?

On Selection 1:

On selection 2 :

The reason for 2nd observation is that we do not have data for 2nd case .

Hence in such cases i want the i want table structure to be retained like we have in 1st scenario with data populated as 0 for , call and meet .

But the below expression is not working

IF(Isnull(Count(DISTINCT{<MT={'Call'}>} ActionPoints)),0,Count(DISTINCT{<MT={'Call'}>} ActionPoints))

Thanks & Regards

Shekar

Re: How to retain table structure even if values corresponding to dimension are not there ?

sunny_talwar — Mon, 07 May 2018 14:05:05 GMT

CITI is not one of the options within MG... so I am unable to replicate the issue by selecting different MGs

Re: How to retain table structure even if values corresponding to dimension are not there ?

sunny_talwar — Mon, 07 May 2018 14:07:21 GMT

For the three MGs I see this

Re: How to retain table structure even if values corresponding to dimension are not there ?

shekhar_analyti — Mon, 07 May 2018 14:44:03 GMT

Hi Sunny Bhai ,

Actually i purposefully added CITI under MG using inline load , apart from normal load from excel .
The purpose to add CITI was to replicate scenario 2 .

However you can add any name under MG which should not have entry in excel MG column .

Please let me know , if i was able to explain myself .

Re: How to retain table structure even if values corresponding to dimension are not there ?

sunny_talwar — Mon, 07 May 2018 14:56:20 GMT

Not sure why the original chart doesn't work... but tried to create a copy of the chart and it seems to be working

Re: How to retain table structure even if values corresponding to dimension are not there ?

shekhar_analyti — Mon, 07 May 2018 15:08:35 GMT

Sunny Bhai , currently i do not have license copy . Requesting you to please share expression or step to achieve above .

Re: How to retain table structure even if values corresponding to dimension are not there ?

sunny_talwar — Mon, 07 May 2018 15:11:16 GMT

Just copy and pasted into a new chart with following expressions

Count(DISTINCT{<MT={'Call'}>} ActionPoints) + Sum(0)

Count(DISTINCT{<MT={'Meet'}>} ActionPoints) + Sum(0)

Count(DISTINCT{<MT={'Conf'}>} ActionPoints) + Sum(0)