topic Re: Can anyone help me to write expression? in QlikView

Can anyone help me to write expression?

durgabhavani — Wed, 25 Mar 2015 05:23:13 GMT

Hi All,

My table contains two fields empname, dayscheck as below

empname
naresh
suresh
pavan kumar
satish
ramesh
swathi
amrutha

dayscheck
0-5 days
6-10 days
15+ days

I have dimension legend for employee name in piechart, now when i click on employeename it should show the "dayscheck" value related to "employee name" in below the chart.

I wrote below expression in chartproperties->presention->textinchart but not geting output as requested above.

=if(GetSelectedCount([empname]),[dayscheck]), 'ALL') (Here 'ALL' denotes if nothing is selected then it should show ALL in below the chart)

Please advice me to write expression in chart?

This is highly appreciated.

Thanks,

Durga

Re: Can anyone help me to write expression?

danieloberbilli — Wed, 25 Mar 2015 05:34:06 GMT

Maybe like this:

=if(GetSelectedCount(empname)>0, 'DayCheck: '& Only(dayscheck),'')

PFA the qvw

Re: Can anyone help me to write expression?

senpradip007 — Wed, 25 Mar 2015 05:42:52 GMT

PFA. Hope it will help.

Re: Can anyone help me to write expression?

durgabhavani — Wed, 25 Mar 2015 06:21:58 GMT

Pradeep,

Can you please share the screen shots of expressions as i am unable to open .qvw files in office.

Thanks,

Durga

Re: Can anyone help me to write expression?

durgabhavani — Wed, 25 Mar 2015 06:24:29 GMT

Thanks for response Daniel! Its almost working but small bug!

I wrote expression as count(dayscheck) and dimension as empname

i wrote your expression in "presentation" tab in "text in chart" field as below

=if(GetSelectedCount(empname)>0, 'DayCheck: '& Only(dayscheck),'ALL')

But i am not getting dayscheck values when clicking on particular empnames?

What might be the problem?

Please advice!

Thanks,

Durga

Re: Can anyone help me to write expression?

durgabhavani — Wed, 25 Mar 2015 06:26:05 GMT

Please share screenshot daniel as before as i am unable to open .qvw files in office.

Thanks,

Durga

Re: Can anyone help me to write expression?

Wed, 25 Mar 2015 13:54:45 GMT

Check this image

try this expressions

Dimen :empname

Expression : Count(empname)

Re: Can anyone help me to write expression?

Wed, 25 Mar 2015 14:11:19 GMT

Hi,

You can try this,

In dimensions:

dayscheck

In expression:

count(empname)

Re: Can anyone help me to write expression?

danieloberbilli — Wed, 25 Mar 2015 22:24:54 GMT

Maybe because you don't have distinct daycheck per empname.

If this is the case then try this: it concatenates all possible values and seperates them with a comma

e.g. like amrutha 0-5 days, 6-10 days:

=if(GetSelectedCount(empname)>0, 'DayCheck: '& Concat(dayscheck, ', '),'')