topic Re: listbox count in QlikView

listbox count

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

Hi all,

Andrey Krylov

Tresesco B

i want to show distinct count in textobjects both red and green distinct count only

and below that listboxes

1 listbox should show only red values(other values should be hidden)

2. second list box only green values(other values should hidden)

these two listboxes should show the respective textbox values.

Re: listbox count

Anonymous — Mon, 05 Nov 2018 11:47:23 GMT

you use your Expression of your Background Color in Dimension and Change it accordingly

e.g. for the green values

=IF(Num([Match Rate],'#,##0.00%')>'97.00%' and Num([Match Rate],'#,##0.00%')<'103.00%',[Business Area Code])

for the red values

=IF(Num([Match Rate],'#,##0.00%'<'97.00%' or Num([Match Rate],'#,##0.00%'>'103.00%',[Business Area Code])

you may Name your listbox e.g. BAC in range or out of range

Re: listbox count

soniasweety — Mon, 05 Nov 2018 11:54:34 GMT

no. user want in listbox only..

im able to get the distinct count but that only count show in listbox how to hide other values?

Re: listbox count

andrey_krylov — Mon, 05 Nov 2018 11:58:25 GMT

Hi Sony. See attached

Re: listbox count

soniasweety — Mon, 05 Nov 2018 12:01:54 GMT

Hi andrey.krylov i got distinct count in text objects. but that same count values should show in list box

how can i do that?

means- in red text object the count is 2-- so one listbox it should show that 2 values

same for green also.

Re: listbox count

sunny_talwar — Mon, 05 Nov 2018 12:21:10 GMT

List box? You will be making selection to these single value count expressions? What do you want to see when you select a count expression? I am not sure I understand why you need a list box? Can you elaborate?

Re: listbox count

soniasweety — Mon, 05 Nov 2018 12:24:25 GMT

Hi sunny,

1.user want to see the count of red colur and green coulr values in text object

2. that same values should display in listbox or strigttable with single dimension.

now red count is 2.. user want to see which are that two codes

Re: listbox count

sunny_talwar — Mon, 05 Nov 2018 12:25:09 GMT

May be try these

=Aggr(Sum(If([Match Rate] > 0.97 and [Match Rate] < 1.03, 1, 0)), [Business Area Code])

=Aggr(Sum(If([Match Rate] > 0.97 and [Match Rate] < 1.03, 0, 1)), [Business Area Code])

Re: listbox count

soniasweety — Mon, 05 Nov 2018 12:28:59 GMT

not count sunny

that values. which are the codes are red which are the codes are green user want to see.

Re: listbox count

sunny_talwar — Mon, 05 Nov 2018 12:33:29 GMT

So, what exactly would you see in the list box? 2G00 repeating twice?

Re: listbox count

andrey_krylov — Mon, 05 Nov 2018 12:52:46 GMT

Oh, I see

Re: listbox count

soniasweety — Mon, 05 Nov 2018 12:55:22 GMT

hmmm thank you sunny given the solution. yours also working fine thanks both of you

Re: listbox count

sunny_talwar — Mon, 05 Nov 2018 12:57:31 GMT

andrey.krylov‌ You can simplify it using this

=Aggr(Only({<[Match Rate] = {">0.97<1.03"}>} [Business Area Code]), [Business Area Code])

and this

=Aggr(Only({<[Match Rate] = {"<=0.97>=1.03"}>} [Business Area Code]), [Business Area Code])

Re: listbox count

andrey_krylov — Mon, 05 Nov 2018 13:08:11 GMT

Thank you, Sunny)) I'll keep it in mind.