topic Re: select field without listbox in QlikView

select field without listbox

Wed, 24 Apr 2013 09:28:08 GMT

Hello

If i wanna make a textbox which shows me the count of an status from a field how would i do so??

example

I have:

START

PROGRESS

DONE

All theses are connected to a company, so i make a count on company and get this:

START 5

PROGRESS 2

DONE 9

How can i then make a text box which shows me the TEXT and the COUNT, BUT without a selection in a listbox, for EACH ??

Re: select field without listbox

datanibbler — Wed, 24 Apr 2013 10:27:38 GMT

Hi,

if I understand your requirement correctly - you can get the count using the >getselectedcount(fieldname)< function and concatenate it to eigher a static text or the contents of a text field using the &.

If any selection is necessary for that, you can include a filter into your expression, enclose it in brackets like {<field=value>}

HTH

Best regards,

DataNibbler

Re: select field without listbox

Wed, 24 Apr 2013 11:41:33 GMT

Try to add three textboxes with the formulas:

=count({1 <status={'START'}>} company)

=count({1 <status={'PROGRESS'}>} company)

=count({1 <status={'DONE'}>} company)

Re: select field without listbox

er_mohit — Wed, 24 Apr 2013 11:47:35 GMT

try this in text object

='START' &Aggr(COUNT(START),Company)

lly, for rest of 2.

hope it helps

Re: select field without listbox

sushil353 — Wed, 24 Apr 2013 11:53:32 GMT

assign your expression to a variable.

use that variable in the text box to show the result of variable.

make sure while assigning the expression to the variable put = sign and use set analysis to get rid of selection effect

like {1}

HTH

Sushil

Re: select field without listbox

sushil353 — Wed, 24 Apr 2013 11:53:38 GMT

assign your expression to a variable.

use that variable in the text box to show the result of variable.

make sure while assigning the expression to the variable put = sign and use set analysis to get rid of selection effect

like {1}

HTH

Sushil

Re: select field without listbox

Wed, 24 Apr 2013 12:03:33 GMT

try this , hope this helps you

= aggr('START ' & Count(START) & ' PROGRESS ' & Count(PROGRESS) &' DONE ' & Count(DONE), company)

Re: select field without listbox

Wed, 24 Apr 2013 12:18:19 GMT

no one ???

Or is there a smarter way to do it??

Re: select field without listbox

manishnarang — Wed, 24 Apr 2013 12:21:37 GMT

Let it be in list box, just

1. Remove the caption

2. Make it read-only (Properties -> General - > select read-only)

is this what you expecting?

Re: select field without listbox

Wed, 24 Apr 2013 13:51:10 GMT

What sould the expression be like? cause i cant get it to work