Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

satishqlik
Contributor

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

Tags (1)
16 Replies
devarasu07
Honored Contributor II

Re: suggest

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
Honored Contributor III

Re: suggest

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". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
satishqlik
Contributor

Re: suggest

PFA for your reference!!!

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

Any help???

devarasu07
Honored Contributor II

Re: suggest

Hi, No attachment,  Tks

Lech_Miszkiewicz
Honored Contributor III

Re: suggest

it is in original post

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
Lech_Miszkiewicz
Honored Contributor III

Re: suggest

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". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
satishqlik
Contributor

Re: suggest

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
Honored Contributor II

Re: suggest

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
Honored Contributor III

Re: suggest

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". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
Community Browser