Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Esteemed Contributor III

Remaining Bars Zero

Hi all,

I have one small doubt.

as i hve a bar chart with two expreions.

REQ: i want to show the  sum(Toplineachieved)     as one bar  and remaing bar values as zero.

how can i do this?

Tags (3)
1 Solution

Accepted Solutions
Highlighted
Valued Contributor III

Re: Remaining Bars Zero

Hi Chanty:

Regards

View solution in original post

10 Replies
Highlighted

Re: Remaining Bars Zero

Remaining bar values? Not sure I understand

Esteemed Contributor III

Re: Remaining Bars Zero

for example...  i want to show  only for banglore location  in that chart and remaing values shud be shown as zero's in the chart

Highlighted
Valued Contributor III

Re: Remaining Bars Zero

Hi Chanty:

Regards

View solution in original post

Highlighted

Re: Remaining Bars Zero

Like this?

Capture.PNG

I used this expression:

Sum([Top Line Target]) + Sum({1}0)

Highlighted
Esteemed Contributor III

Re: Remaining Bars Zero

sunny i didnt get ur sollution?

Highlighted
Esteemed Contributor III

Re: Remaining Bars Zero

thanx Manuel.  its fine enough.

Highlighted
Honored Contributor

Re: Remaining Bars Zero

Hi Chanty,

Do you mean this Situation, where you have Zero and this Zero must be shown on Chart

today.PNG

Highlighted

Re: Remaining Bars Zero

Sorry, I might have missed your requirement. But I guess manucamon‌ solution is what you were looking for? If it still did not fulfill your requirement, would you be able to elaborate on what you are looking for?

Highlighted
Esteemed Contributor III

Re: Remaining Bars Zero

thnx sunny... its fine  nd good his sollution. thnx fr ur attempt as always