working fine with straight table but not with kpi's charts

[kunkumnaveen]

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

[kunkumnaveen]

HELLO sunny

please find the attachment,i am getting 1

thanks

naveen

[sunny_talwar]

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)

[kunkumnaveen]

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)....

[kunkumnaveen]

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)

[sunny_talwar]

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?

[kaushiknsolanki]

Hi,

Try this.

Sum({<LOCATION={"*CHANDERIA*"},ADATE={"$(=max(ADATE))"}>}OVERALL_SCR)

Regards,

Kaushik Solanki

[kunkumnaveen]

hello sunny

[sunny_talwar]

The attached qvw doesn't have LOCATION field in it. Seems like it was dropped:

[kunkumnaveen]

hello sunny

use this file ,the one i had send to you earlier had missing out unsaved work

[sunny_talwar]

Seems to be working for me:

When I select ZAWAR

When I select DEBARI