topic How to keep all the column Value in charts in QlikView

How to keep all the column Value in charts

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

Hi all

Below is my tableA

lang, year, amt

tamil, 2013,3409

english,2013,8953

tamil,2014,4852

in chart if i select year 2014 i am getting only lang 'tamil' but i want both with the amt as 0 for english.

TIA

Re: How to keep all the column Value in charts

martinpohl — Sun, 17 Dec 2017 11:34:33 GMT

there is no combination between year 2014 and english

so if should be, you have to generate for all lang and all year a line 0 as amt.

and deselect suppress null values in presentation tab

Re: How to keep all the column Value in charts

mdmukramali — Sun, 17 Dec 2017 11:41:03 GMT

Hi,

you can try something like .

Expression : =sum(amt)+ Avg({1} 0)

and unchecked Suppress Zero-Values option in presentation tab..

Thanks,

Mukram.

Re: How to keep all the column Value in charts

Anil_Babu_Samineni — Sun, 17 Dec 2017 11:41:37 GMT

Not sure, I understand your question? What are the measures you used. Will you provide sample result set?

Re: How to keep all the column Value in charts

Anonymous — Sun, 17 Dec 2017 11:56:34 GMT

Hi Anil,

dimension is Lang

Exp is sum(amt)

TIA

Re: How to keep all the column Value in charts

Anil_Babu_Samineni — Sun, 17 Dec 2017 11:59:04 GMT

Still, Not make sense to me. Because the English comes from 2014 2013 and your filter looks 2014. Why you want to club them. May be look Mohammed Response..