topic Re: Data in text objet in QlikView

Data in text objet

Mon, 30 Jun 2014 16:54:59 GMT

I have this chart.

Dimension,

TUK_ID

Expresion

If(count(distinct RAZ_ID)> vNum , Count(distinct RAZ_ID))

Now i need to put in a tex objet a count of difertens RAZ_ID .

i DO.

IF(AGGR(COUNT( DISTINCT RAZ_ID)>vNum), count( disctint RAZ_ID) , TUK_ID)

Please help.

Re: Data in text objet

Mon, 30 Jun 2014 17:22:25 GMT

if your expression is valid, all you need to do is put in

=IF(AGGR(COUNT( DISTINCT RAZ_ID)>vNum), count( disctint RAZ_ID) , TUK_ID)

Re: Data in text objet

Anonymous — Mon, 30 Jun 2014 17:50:55 GMT

there are a couple of syntax errors in that expression. but setting them aside, why do you need aggr in a text box? could you give us an example of what the expected output needs to look like? also, what is the expression for vNum?

like Robert said, put an = sign in front of your expression and try a text box...it will tell you exactly where the syntax errors are.

i'm not sure i understand your requirement, but i don't think you are referring to concat.

Re: Data in text objet

maxgro — Mon, 30 Jun 2014 18:11:05 GMT

try with

=count({$ <TUK_ID={"=count(distinct RAZ_ID)>vNum"}>} DISTINCT RAZ_ID)