Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
What making me confuse is i am using same dimension and same expression in two diff charts (kpis,straight table),but i am getting two diff results
i mean ..my default when end user open dashboard he as to see all the location aduit score ...which is working fine in both table chart and kpi chart ....
if he goes feather and select only particular location from the drop down then he should only see that selected location with score ...
which is working great in table but its not working in kpis charts,
what i looking is when i select location, only selected KPI chart has to show the value the rest kpi chart needle should be at zero....
straight table:
dimension:LOCATION
expression:Sum({<ADATE={"$(=max(ADATE))"}>}OVERALL_SCR)(working fine)
kpi chart:(chanderia kpi chart)
dimension:LOCATION
expression:Sum({<LOCATION={'CHANDERIA'},ADATE={"$(=max(ADATE))"}>}OVERALL_SCR)
Help me in resloving this task,
Please find the attachment(data screen short)
thanks
naveen
HELLO sunny
please find the attachment,i am getting 1
thanks
naveen
So if the if condition is working, we need to check if the expression is working or not:
Sum({<LOCATION = {'DEBARI'}, ADATE ={"$(=Max(ADATE))"}>} OVERALL_SCR)
Sum({<LOCATION = {'ZAWAR'}, ADATE ={"$(=Max(ADATE))"}>} OVERALL_SCR)
With or without selection in LOCATION, they should not be changing? Are these changing? If they are, then may be add this:
Sum({<LOCATION = {'DEBARI'}, ADATE = {"$(=Max({<LOCATION>}ADATE))"}>} OVERALL_SCR)
Sum({<LOCATION = {'ZAWAR'}, ADATE = {"$(=Max({<LOCATION>}ADATE))"}>} OVERALL_SCR)
HELLO SUNNY,
there are not changing even thought i select chanderia from drop down.......i
Sum({<LOCATION = {'DEBARI'}, ADATE ={"$(=Max(ADATE))"}>} OVERALL_SCR)
Sum({<LOCATION = {'ZAWAR'}, ADATE ={"$(=Max(ADATE))"}>} OVERALL_SCR)....
sunny my doubt is if this expression is working very fine with chanderia but y not debari and zawar even though we change location name
=If(SubStringCount(Concat(DISTINT LOCATION, ', '), 'CHANDERIA') = 1,Sum({<LOCATION = {'CHANDERIA'}, ADATE ={"$(=Max(ADATE))"}>} OVERALL_SCR), 0)
That's what I am wondering. I would expect them to work the same way. Would it be possible for you to share your application?
Hi,
Try this.
Sum({<LOCATION={"*CHANDERIA*"},ADATE={"$(=max(ADATE))"}>}OVERALL_SCR)
Regards,
Kaushik Solanki
hello sunny
The attached qvw doesn't have LOCATION field in it. Seems like it was dropped:
hello sunny
use this file ,the one i had send to you earlier had missing out unsaved work
Seems to be working for me:
When I select ZAWAR
When I select DEBARI