Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
In Qliksense,I have created stacked bar with multiple measures.
and I enabled show Lables for each and every measure
In this am getting values overlap issue with 0''s
So here I don't want to show 0 values
Already I have checked surprise null value but not working in this.
Any ideas??
Please suggest!!
Any help will be appreciated, thanks in advance!!
Hi,
Try below methods,
1) Try to Create Calculated dimension like below,
=aggr(IF(Sum(Sales)>0,Year,0),Year)
2) Try to use below kind Set expression:
sum({<Sales={">0"}>}Sales)
if not working, try to share your app with mock data. that would be easy for us to check and help you
Hope this helps you
Regards,
Deva
Devarasu's advice may be correct.
btw Satish - you have made my day by "surprised null values"
Cheers !
PFA for your reference!!!
That's is working fine in qlikview but not in qliksense.
Any help???
Hi, No attachment, Tks
it is in original post
In QS i get the same what you sent us in QV.
is this what you are trying to achieve?
I did it from other extension (github amcombo chart) and enabled stacked
If I enable show lables for each measure we are getting overlap issue with 0s.
suppose for p1 measure if enable show lables this is fine
but 2nd measure p2 If I enable show lables it is showing p2 value and p1 is 0
as same as
for p3--->p3 value and 0's for p1,p2
for p4--->p4 value and 0's for p1,p2,p3
Here I don't want to show 0's
Hi,
Like this? note: if you convert existing your .qvw app into sense "0" not suppressed. after re-created in qlik sense with exclude null option should be ok.
Sorry mate- i do not get it. Are you referring to "on hover" appearance like the one attached?