Passing Multiple Values into Variable

[#1]

i am trying to pass multiple values into variable and clear variable selection

not working

my Variable

vGabbro=DeveloperDesc

i use Expression

=(Sum({$<CargoTypeDesc={'GABBRO'},DeveloperDesc={'$(vGabbro)'}>}EstimatedQuantity))

=(Sum({$<CargoTypeDesc={'GABBRO'},DeveloperDesc={'$(= vGabbro)'}>}EstimatedQuantity))

i tried both the ways

default variable should select all developers but it is not

i miss tick help me please

[#2]

Thank you Thirumala,

i added some data i just made Estimation/2 as ActualQuantity

still it's same

i don't find how to make my new attachment hear but it same no change

[sasiparupudi1 · Accepted solution]

set your variable  vGabbro to the following value including the =

=chr(39)&'ASHGHAL'&chr(39)&','&chr(39)&'RAIL'&chr(39)

your set expression should be as follows

Sum({$<CargoTypeDesc={'GABBRO'},DeveloperDesc={$(vGabbro)}>}EstimatedQuantity)

hth

Sasi

[#4]

Thnak you very much sasidhar, it works fine

one more step i need ,how to clear variables after choosing one value

[#5]

HI Sasi,

I need to build 10 variables like Gabbro,Limestone, washsand,nijansand..........

it is working for only first one ,developers for all materials are same (ASHGHAL and RAIL)

[#6]

I am building like this

My developers :ASGHAL, RAIL, two more but they no data , i just prepare sample data

1st Gauge is GABBRO

2nd is LIME STONE

3rd WASHSAND

4th NIJAN

......

...

50 is for the developer % when i click number gauge should filter for the developer..

[#7]

but it my gauge is not showing initially,it showing "Allocated Memory Excited"

[#8]

Any help guys it will be a best dashboard if i can achieve this functionality..please help

[sunny_talwar]

Can you check the attached. Used Kush's expression and added to the variable

[#10]

HI Sunny Thank you very much for responce

i see same thing when open

[sunny_talwar]

There was a trigger which changed the variable, try now