topic Re: get variable dynamically and use it in set analisys in QlikView

get variable dynamically and use it in set analisys

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hi,

I am trying to create 1 application in which when nothing is selected, my minimum and maximum, is equal to my maximum and to be able to use in a set analisys.

this is what i want but with no selection:

i don't want the Record with "100" in Factkey:

i have tried with something like this but with no sucess

let vMinFactDate=if($(vSelected) = 0,'"%(=max(FactKey))"','"%(=min(FactKey))"');"

can you help me ?

a small apllication in attach

thanks in advance

Ricardo

Re: get variable dynamically and use it in set analisys

vishsaggi — Tue, 16 May 2017 15:46:56 GMT

I might be wrong, just check this may be?

See attached.

Re: get variable dynamically and use it in set analisys

Anonymous — Tue, 16 May 2017 15:57:53 GMT

thanks

vishsaggi

It works but what I wanted was to change the contents of the variable vDisplayMinFactDate because I have many set analisys expressions that use it.

it's possible ?

Re: get variable dynamically and use it in set analisys

vishsaggi — Tue, 16 May 2017 16:16:50 GMT

Can you elaborate please. I did not change any variable values in that file. Can you give some examples?

Re: get variable dynamically and use it in set analisys

Anonymous — Tue, 16 May 2017 16:57:13 GMT

hi Vishwarath Nagaraju

i want to use the variable (for instance) "vOldValue"

where :

let vOldValue='sum({<FactKey={'& chr(39) & chr(36) &'(vDisplayMinFactDate)'& chr(39) & '}>} #Value)';

so i want to change the variable "vDisplayMinFactDate" depending on the selection.

"Min value" if i have anyting selected

"Max value" if i dont have any selection.

Now it's clear to you?

Regards

Ricardo

Re: get variable dynamically and use it in set analisys

Anonymous — Tue, 16 May 2017 17:49:06 GMT

I'm a little confused but does this get you what you want?

let vDisplayMinFactDate=if($(vSelected)=0,max({1<FactKey = {"$(=max(FactKey))"}>} FactKey),min({1<FactKey = {"$(=min(FactKey))"}>} FactKey))

Re: get variable dynamically and use it in set analisys

vishsaggi — Tue, 16 May 2017 17:49:35 GMT

Where do you want to display those? Can you replicate your output you are expecting when you select and when you don't ? The variable should function based on selections. No changes were done to them.

Re: get variable dynamically and use it in set analisys

Anonymous — Wed, 17 May 2017 08:48:08 GMT

Wallo

i got "Syntax error

Unexpected token: 'GetSelectedCount', expected nothing

let vDisplayMinFactDate =if(=>>>>>>GetSelectedCount<<<<<<(FactKey)=0, max({1<FactKey = {""}>} FactKey), min({1<FactKey = {""}>} FactKey))"

Re: get variable dynamically and use it in set analisys

Anonymous — Wed, 17 May 2017 08:54:40 GMT

i want to have a lot of expressions using a variable depending on select.

let vOldValue= 'sum({<FactKey={'& chr(39) & chr(36) &'(vDisplayMinFactDate)'& chr(39) & '} >} #Value)';.