Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
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....

Community Browser