topic Re: Passing Multiple Values into Variable in QlikView

Passing Multiple Values into Variable

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Passing Multiple Values into Variable

Fri, 03 Jun 2016 06:20:33 GMT

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

please

Re: Passing Multiple Values into Variable

Anonymous — Fri, 03 Jun 2016 08:45:03 GMT

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!

Re: Passing Multiple Values into Variable

Fri, 03 Jun 2016 11:28:21 GMT

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

Re: Passing Multiple Values into Variable

Kushal_Chawda — Fri, 03 Jun 2016 11:34:15 GMT

You should use Concat function, try below expression without variable

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

Re: Passing Multiple Values into Variable

Fri, 03 Jun 2016 11:35:00 GMT

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

Re: Passing Multiple Values into Variable

Fri, 03 Jun 2016 11:37:16 GMT

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

Re: Passing Multiple Values into Variable

Anonymous — Fri, 03 Jun 2016 11:41:30 GMT

Hi channa:

See attached example.

Kind regards

Re: Passing Multiple Values into Variable

Fri, 03 Jun 2016 11:42:39 GMT

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

Re: Passing Multiple Values into Variable

trdandamudi — Fri, 03 Jun 2016 11:43:07 GMT

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.

Re: Passing Multiple Values into Variable

Fri, 03 Jun 2016 11:52:23 GMT

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

Re: Passing Multiple Values into Variable

sasiparupudi1 — Fri, 03 Jun 2016 12:25:38 GMT

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

Re: Passing Multiple Values into Variable

Fri, 03 Jun 2016 13:31:14 GMT

Thnak you very much sasidhar, it works fine

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

Re: Passing Multiple Values into Variable

Fri, 03 Jun 2016 13:51:47 GMT

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)

Re: Passing Multiple Values into Variable

Fri, 03 Jun 2016 13:59:37 GMT

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

Re: Passing Multiple Values into Variable

Fri, 03 Jun 2016 18:13:29 GMT

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

Re: Passing Multiple Values into Variable

Fri, 03 Jun 2016 19:04:11 GMT

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

Re: Passing Multiple Values into Variable

sunny_talwar — Fri, 03 Jun 2016 19:14:52 GMT

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

Re: Passing Multiple Values into Variable

Sat, 04 Jun 2016 03:07:19 GMT

HI Sunny Thank you very much for responce

i see same thing when open

Re: Passing Multiple Values into Variable

sunny_talwar — Sat, 04 Jun 2016 12:20:42 GMT

There was a trigger which changed the variable, try now