Can anyone help me to write expression?

[durgabhavani]

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

[danieloberbilli]

Maybe like this:

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

PFA the qvw

[senpradip007]

PFA. Hope it will help.

[durgabhavani]

Pradeep,

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

Thanks,

Durga

[durgabhavani]

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

[durgabhavani]

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

Thanks,

Durga

[#7]

Hi

Check this image

try this expressions

Dimen :empname

Expression : Count(empname)

[#8]

Hi,

You can try this,

In dimensions:

                 dayscheck

In expression:

             count(empname)

[danieloberbilli]

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, ', '),'')