topic Re: Display value and % on chart in QlikView

Display value and % on chart

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

Hi All

How can I display count and % together from total count on the chart. I can easily display the count below but also would like to display

the % of each priority against what total we have in that year.. for example below

35/55*100 = 70%

10/55*100 = 18.18%

I have attached the Qvw file here..

Re: Display value and % on chart

sunny_talwar — Fri, 14 Jul 2017 15:34:04 GMT

May be this

Dual(Count & Chr(10) & Num(Count/Sum(TOTAL <Year> Count), '##.00%'), Count)

Re: Display value and % on chart

vijaysahu2 — Mon, 17 Jul 2017 10:25:20 GMT

Hi Sunny

Your given file does work as expected though I had provided just a sample of what my original issue is. I tried to mapped values in my expression from yours but this is not working at all. Below is my original chart Where I want to

display count and % together. There are two dimensions created one is Priority Severity and DateDrillDown (year, Month,week) and only one expression

count({<DisplayFlag = {1}, [Date Type] = {'CloseResolveDate'}>} [Reference Number (All)])

I used your expression to replace mine

Dual(Count & Chr(10) & Num(Count/Sum(TOTAL <Year> Count), '##.00%'), Count)

Mine - I have replaced count to my expression.. and Year has been Replaced by My Dimension DatedrillDown

Dual(count({<DisplayFlag = {1}, [Date Type] = {'CloseResolveDate'}>} [Reference Number (All)]) & Chr(10) & Num(count({<DisplayFlag = {1}, [Date Type] = {'CloseResolveDate'}>} [Reference Number (All)]) /Sum(TOTAL <DatedrillDown> count({<DisplayFlag = {1}, [Date Type] = {'CloseResolveDate'}>} [Reference Number (All)]) ), '##.00%'), count({<DisplayFlag = {1}, [Date Type] = {'CloseResolveDate'}>} [Reference Number (All)]) )

Please advise me how to solve this problem.

Re: Display value and % on chart

sunny_talwar — Mon, 17 Jul 2017 11:09:51 GMT

You need to use an aggr() function between Sum and Count function.... May be like this

Dual(Count({<DisplayFlag = {1}, [Date Type] = {'CloseResolveDate'}>} [Reference Number (All)]) & Chr(10) & Num(Count({<DisplayFlag = {1}, [Date Type] = {'CloseResolveDate'}>} [Reference Number (All)]) /Sum(TOTAL <[$(=GetCurrentField(DatedrillDown))]> Aggr(Count({<DisplayFlag = {1}, [Date Type] = {'CloseResolveDate'}>} [Reference Number (All)]), [Priority Severity], [$(=GetCurrentField(DatedrillDown))]), '##.00%'), Count({<DisplayFlag = {1}, [Date Type] = {'CloseResolveDate'}>} [Reference Number (All)]) )