topic Re: hiding in Bar Graph in QlikView

hiding in Bar Graph

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

i want to hide only BLACK shaded bar,how it is possible?.

Re: hiding in Bar Graph

kaushiknsolanki — Sun, 28 May 2017 19:12:47 GMT

Hi,

You can do it by eliminating the data that corresponds to that bar which is c_id =4.

Try this expression.

Count({<c_id -= {"4"}>}Field)

Regards,

Kaushik Solanki

Re: hiding in Bar Graph

Anonymous — Sun, 28 May 2017 19:18:24 GMT

given exp is not working.

Re: hiding in Bar Graph

kaushiknsolanki — Sun, 28 May 2017 19:26:59 GMT

What expression do you have.

if possible share your application.

Regards,

Kaushik Solanki

Re: hiding in Bar Graph

Anonymous — Sun, 28 May 2017 19:49:10 GMT

thanks, its working but i didn't get one thing while i am using 2 exp in graph that time c_id=4 is visible for 2nd exp.

Re: hiding in Bar Graph

Anonymous — Sun, 28 May 2017 19:51:02 GMT

Re: hiding in Bar Graph

Siva_Sankar — Mon, 29 May 2017 01:46:47 GMT

Because second expression it counts all C_ids but in the first expression C_id is excluded.

Count({<c_id-={"4"}>c_id}) meaning count all c_ids excluding c_id=4

Count(c_id) count of all c_ids without any exception.

-Siva

Re: hiding in Bar Graph

Anonymous — Mon, 29 May 2017 08:42:42 GMT

ya but one thing you noticed there? top on the bar 5 is there and total count is 6 that means 2nd exp doesn't count that 4,it shows only in bar..

Re: hiding in Bar Graph

Anonymous — Mon, 29 May 2017 11:46:27 GMT

It depends on what expression you have used to display that 5 count. If you have excluded c_id=4 in that expression then it won't appear in the count.