Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
soniasweety
Valued Contributor III

listbox count

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.

Tags (2)
13 Replies
Partner
Partner

Re: listbox count

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

soniasweety
Valued Contributor III

Re: listbox count

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?

andrey_krylov
Valued Contributor

Re: listbox count

Hi Sony. See attached

soniasweety
Valued Contributor III

Re: listbox count

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

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?

soniasweety
Valued Contributor III

Re: listbox count

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

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])


Capture.PNG

soniasweety
Valued Contributor III

Re: listbox count

not count sunny

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

Re: listbox count

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