Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
satishqlik
Creator II
Creator II

suggest

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!!

16 Replies
devarasu07
Master II
Master II

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

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Devarasu's advice may be correct.

btw Satish - you have made my day by "surprised null values"

Cheers !

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
satishqlik
Creator II
Creator II
Author

PFA for your reference!!!

That's is working fine in qlikview but not in qliksense.

Any help???

devarasu07
Master II
Master II

Hi, No attachment,  Tks

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

it is in original post

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

In QS i get the same what you sent us in QV.

is this what you are trying to achieve?

TEST.png

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
satishqlik
Creator II
Creator II
Author

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

devarasu07
Master II
Master II

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.

1.JPG

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Sorry mate- i do not get it. Are you referring to "on hover" appearance like the one attached?

TEST.png

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.