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]

by default my expression not taking all developers..it saying missing max min..little bit urgent

please

[Anonymous]

Hi channa,

Your var -> =Concat(DISTINCT Chr(39)&DeveloperDesc&chr(39),',')

Your Expression ->  =(Sum({$<CargoTypeDesc={'GABBRO'},DeveloperDesc={$(vGabbro)}>}ActualQuantity))

You can change all your vars with concat, to get all values selected.

Kind regards!

[#4]

Thank you Manuel,

i tried by default my dashboard not showing any data "Allocated Memory Exceeded"

i use the expression as you suggest

my gauge should show all developers by default and need clear to clear variables

i don't find much help in existing topics can you please help me with this guys..

[Kushal_Chawda]

You should use Concat function, try below expression without variable

(Sum({$<CargoTypeDesc={"GABBRO"},DeveloperDesc={"=Concat(DISTINCT Chr(39)&DeveloperDesc&chr(39),',')"}>}EstimatedQuantity))

[#6]

it should be simple i am missing trick ..some one must use like this..

[#7]

i need variable because i need to filter Gauge for ASHGHAL, RAIL......when click on number

[Anonymous]

Hi channa:

See attached example.

Kind regards

[#9]

Thank you very much  Kushal for response

initially when user open report my expression should take all the values from variable only 

i can't use filter because i need to build similar gauges for all materials there are 10 materials

[trdandamudi]

I noticed that your field "ActualQuantity" is null and might be that is the reason you are not able to see any records. Once you fix it and you still have the issue can you please post the updated qlikview file.