topic Re: How does Expression work ? in QlikView

How does Expression work ?

Thu, 04 Dec 2014 04:17:18 GMT

Hi All,

As shown in the graph below is it possible for me to get the count(individual record) * 100 / sum (total record) in the same graph?

Re: How does Expression work ?

SunilChauhan — Thu, 04 Dec 2014 04:33:45 GMT

(count(distinct record) * 100) / sum (total record)

Re: How does Expression work ?

amit_saini — Thu, 04 Dec 2014 04:47:50 GMT

Sai,

As Chauhan suggested it should work.

Thanks,
As

Re: How does Expression work ?

Thu, 04 Dec 2014 05:06:43 GMT

Sum(dimension) does not return me any value when I use it in expression. I have only one dimension to it. To be more clear.. this is how the data looks.

Sales person Sales

A 2

B 12

C 11

.. ..

when I plot the graph against sales person Vs sales and I try to get the expression % sold with count ( A) * 100 / sum (A+B+C). I do not get any value. I do not get any value when I try to get only the Sum(Sales). Is it wrong with the data ?

Re: Re: How does Expression work ?

amit_saini — Thu, 04 Dec 2014 05:32:03 GMT

Sai ,

Like this???

Thanks,

Re: Re: How does Expression work ?

Thu, 04 Dec 2014 05:44:48 GMT

Thanks All. It was my mistake.

Re: How does Expression work ?

amit_saini — Thu, 04 Dec 2014 05:45:33 GMT

Good