Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

select field without listbox

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 ??

1 Solution

Accepted Solutions
Not applicable
Author

Try to add three textboxes with the formulas:

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

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

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

View solution in original post

9 Replies
datanibbler
Champion
Champion

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

Not applicable
Author

Try to add three textboxes with the formulas:

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

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

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

er_mohit
Master II
Master II

try this in text object

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

lly, for rest of 2.

hope it helps

sushil353
Master II
Master II

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

sushil353
Master II
Master II

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

Not applicable
Author

HI

try this , hope this helps you

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

Not applicable
Author

no one ???

Or is there a smarter way to do it??

manishnarang
Partner - Creator
Partner - Creator

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?

Not applicable
Author

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