Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Passing Multiple Values into Variable

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

21 Replies
Not applicable
Author

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
Master III
Master III

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

Not applicable
Author

Thnak you very much sasidhar, it works fine

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

Not applicable
Author

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)

Not applicable
Author

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

Variable.PNG

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

HI Sunny Thank you very much for responce

i see same thing when open Capture.PNG

sunny_talwar

There was a trigger which changed the variable, try now