Solved: Hide YEAR when any quarter is null - Qlik Community

Report Inappropriate Content · ‎2016-01-25

Hi All,

I have one dimension and three expressions

Dimesnion - if(DATE>='12/31/1980',YEAR)

Expression1 - avg({<NAME={'A'}>VALUE))/100

Expression2 - avg({<NAME={'B'}>VALUE))/100

Expression3 - avg({<NAME={'C'}>VALUE))/100

Now i want to hide YEAR in my chart for any quarter Q1,Q2,Q3,Q4 is null for those NAMES in the expression, then whole YEAR Should not be shown in my Chart.

Please let me know if there are any concerns

Thanks

Avinash

jagan‌

Report Inappropriate Content · ‎2016-01-29

Hi All,

if(isnull(((avg({<NAME={'A'},QUARTER={'Q4'}>}VALUE))/100))

or ((avg({<NAME={'A'},QUARTER={'Q4'}>}VALUE))/100=0

or

isnull(((avg({<NAME={'A'},QUARTER={'Q3'}>}VALUE))/100

or ((avg({<NAME={'A'},QUARTER={'Q3'}>}VALUE))/100)=0

or

isnull(((avg({<NAME={'A'},QUARTER={'Q2'}>}VALUE))/100

or ((avg({<NAME={'A'},QUARTER={'Q2'}>}VALUE))/100=0

or

isnull(((avg({<NAME={'A'},QUARTER={'Q1'}>}VALUE))/100

or ((avg({<NAME={'A'},QUARTER={'Q1'}>}VALUE))/100=0

, null(),

((avg({<NAME={'A'}>}VALUE))/100)

View solution in original post

Anonymous · ‎2016-01-25

Any sample app or data?

Suppress Null Values did not work?

tamilarasu · ‎2016-01-25

Hi Avinash,

Enable "Suppress When Value is Null" option in dimension tab.

Report Inappropriate Content · ‎2016-01-25

No It is not working.

We have given suppress value is null option as check in dimension but no changes are sone.

Any suuggestions

Report Inappropriate Content · ‎2016-01-25

No it is not working

tamilarasu · ‎2016-01-25

Can you post sample application?

jagan · ‎2016-01-25

HI,

Try like this

Dimension - if(DATE>='12/31/1980',YEAR)

Expression1 - If(Count(DISTINCT Quarter) = 4, avg({<NAME={'A'}>VALUE))/100, Null())

Expression2 - If(Count(DISTINCT Quarter) = 4, avg({<NAME={'B'}>VALUE))/100, Null())

Expression3 - If(Count(DISTINCT Quarter) = 4, avg({<NAME={'C'}>VALUE))/100, Null())

If not working can you attach some sample file.

Regards,

Jagan.

PradeepReddy · ‎2016-01-25

try like this in calculated dimension.. and enable the 'Suppress When Value is Null'

=if(aggr(sum(if(isnull(Quarter),1)),Year)=0,Year)

Edit:

=if(Date> '12/31/1980' and aggr(sum(if(isnull(Quarter),1)),Year)=0,Year)

deepakqlikview_123 · ‎2016-01-25

dude,

its already done in country specific charts.

take the reference.

Report Inappropriate Content · ‎2016-01-25

In which chart depak in country specific.

deepaktibhe‌