topic Re: Remaining Bars Zero in QlikView

Remaining Bars Zero

Chanty4u — Mon, 13 Jun 2016 10:50:17 GMT

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?

Re: Remaining Bars Zero

sunny_talwar — Mon, 13 Jun 2016 10:52:01 GMT

Remaining bar values? Not sure I understand

Re: Remaining Bars Zero

Chanty4u — Mon, 13 Jun 2016 10:52:54 GMT

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

Re: Remaining Bars Zero

Anonymous — Mon, 13 Jun 2016 10:53:30 GMT

Hi Chanty:

Regards

Re: Remaining Bars Zero

sunny_talwar — Mon, 13 Jun 2016 10:54:46 GMT

Like this?

I used this expression:

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

Re: Remaining Bars Zero

Chanty4u — Mon, 13 Jun 2016 11:10:53 GMT

sunny i didnt get ur sollution?

Re: Remaining Bars Zero

Chanty4u — Mon, 13 Jun 2016 11:11:22 GMT

thanx Manuel. its fine enough.

Re: Remaining Bars Zero

beck_bakytbek — Mon, 13 Jun 2016 11:58:08 GMT

Hi Chanty,

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

Re: Remaining Bars Zero

sunny_talwar — Mon, 13 Jun 2016 12:01:20 GMT

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?

Re: Remaining Bars Zero

Chanty4u — Mon, 13 Jun 2016 12:05:46 GMT

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

Re: Remaining Bars Zero

sunny_talwar — Mon, 13 Jun 2016 12:09:04 GMT

Sounds good