Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

100% at stacked bars only with expressions

Hi there,

my name is Walter and I am new at qlikview and as you can guess, I have some problems.

I need to make a diagram (bar) with only two expressions:

count(SW_VERSION)                                 (=open)

count(HOSTNAME) - count(SW-VERSION)  (=closed)

and now I need them both stacked and the one bar alltogehter at 100%.

e.g. 46%open <--> 54%closed.

If I am trying to use relative, it appears 100%open <--> 100%closed.

With numbers only, everything is fine.

What did I do wrong?

Thx in advance.

Edit: And another question: If I need a count like this

count({<REV_ABC={'bla'}, REV_DEF={'blub'}>} HOSTNAME)

but after {'blub'}>} the HOSTNAME is not redcolored and wont work....

1 Solution

Accepted Solutions

Re: 100% at stacked bars only with expressions

Try these expressions:

1) count(SW_VERSION)/count(HOSTNAME)                                              (=open)

2) (count(HOSTNAME) - count(SW-VERSION))//count(HOSTNAME)            (=close)

Not sure I understand your second question. Do you want to elaborate on it?

2 Replies

Re: 100% at stacked bars only with expressions

Try these expressions:

1) count(SW_VERSION)/count(HOSTNAME)                                              (=open)

2) (count(HOSTNAME) - count(SW-VERSION))//count(HOSTNAME)            (=close)

Not sure I understand your second question. Do you want to elaborate on it?

Not applicable

Re: 100% at stacked bars only with expressions

Many thx!

It works....