Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe like this:
=if(GetSelectedCount(empname)>0, 'DayCheck: '& Only(dayscheck),'')
PFA the qvw
PFA. Hope it will help.
Pradeep,
Can you please share the screen shots of expressions as i am unable to open .qvw files in office.
Thanks,
Durga
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
Please share screenshot daniel as before as i am unable to open .qvw files in office.
Thanks,
Durga
Hi
Check this image
try this expressions
Dimen :empname
Expression : Count(empname)
Hi,
You can try this,
In dimensions:
dayscheck
In expression:
count(empname)
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, ', '),'')