topic Bar Chart Pop-up and Concat expression help. in QlikView

Bar Chart Pop-up and Concat expression help.

Thu, 26 Nov 2009 22:22:30 GMT

Hi,

I am trying to create a Pop-Up expression, that Concat's values (Level), with it's value(count(Stu_Prog))

So that the output is something like : TP:80 / UG:9 etc etc..

I've created an expression, but it doesn't seem to work when I put in the count(Stu_Prog) part.

Any suggestions? I might be missing something.

Much appreciated!

Xena

Fri, 27 Nov 2009 01:19:35 GMT

Hello Xena,

Is this way u r looking for , attached is the solution

Thanks

Talha

Fri, 27 Nov 2009 01:41:45 GMT

Hi Talha,

Thanks for your response.

However I need the values to be concatenated, as there may be more than 1 value for 'Level'

I see in the help , the concat function doesn't allow aggregation functions like count etc.

Thanks,

Xena

Fri, 27 Nov 2009 13:48:31 GMT

Since there are two types of level, i could come up with this, it shows the result as required by you,see if this can help

'UG:' & count(if(Level='UG',Stu_Prog)) & ' ' & 'TP:' & count(if(Level='TP',Stu_Prog))

regards

peter

Fri, 27 Nov 2009 15:56:06 GMT

Thanks Peter!