topic Selected field value should store in variable in QlikView

Selected field value should store in variable

jagannalla — Mon, 27 Jun 2011 07:33:38 GMT

Hi,

I had three fields they are Group,Min,Max from one table. I had taken Group as field in the listbox,Min & Max as expression in same listbox like followin image:

- Now i want to store Min value of A in one variable and Max value in another variable after marking A

- If i select B i want to store Min value of B in one variable and Max value in another variable.

The four variables are like this vMInA,vMaxA,vMinB,vMaxB.

How to solve this problem

Selected field value should store in variable

Miguel_Angel_Baeyens — Mon, 27 Jun 2011 07:49:10 GMT

Hello,

Go to the Settings menu, Document properties, Triggers tab. Select the fields event and make a new action OnSelect and OnChange, External, Set Variable, select your variables and set the values using Min() and Max() functions.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Selected field value should store in variable

kaushiknsolanki — Mon, 27 Jun 2011 07:52:34 GMT

Hi,

For vMinA Assign this value '=min({<Group= {"A"}>}MinCure)

For vMaxA Assign this value '=max({<Cure = {"A"}>}MinCure)

Use same thing for vMinB and vMaxB

Regards,

Kaushik Solanki

Selected field value should store in variable

jagannalla — Mon, 27 Jun 2011 09:01:36 GMT

kaushik,

But after selecting A it should assign a value to variable.

For eg:

1. if i select A then vMInA should hold the value 2 and vMaxA should hold the value 6. If it is unselected then vMinA,vMaxA should empty.

2. if i select B then vMInB should hold the value 1.58 and vMaxB should hold the value 1.65. If it is unselected then vMinB,vMaxB should empty.

Miguel,

Your logic is good. But when i unselect the variable should be empty and one more think is what about vMinB variable

Selected field value should store in variable

kaushiknsolanki — Mon, 27 Jun 2011 09:14:13 GMT

Hi,

Ok try this.

for vMinA '=if(wildmatch(GetFieldSelections(Group),'A''),min({<Group= {"A"}>}MinCure),0)

Like wise use for other variable too.

Regards,

Kaushik Solanki

Selected field value should store in variable

jagannalla — Mon, 27 Jun 2011 09:24:12 GMT

Hi,

Thanks kaushik it's working...

Can you please solve the solution of last two posts in this link :- LastTwoPosts

Selected field value should store in variable

kaushiknsolanki — Mon, 27 Jun 2011 10:04:29 GMT

Hi,

Can you please mark this post as answered.

Regards,

Kaushik Solanki

Selected field value should store in variable

swuehl — Mon, 27 Jun 2011 12:18:45 GMT

Hi jagannalla,

just adding a note:

If you want a multiselect (like in your screenshot in OP), you need to use wildcards for the wildmatch (i.e. wildmatch(GetFieldSelections(Group),'*A*') or use index function instead.

(Group names must be unique even in part then)

Selected field value should store in variable

jagannalla — Mon, 27 Jun 2011 13:31:45 GMT

swuehl,

Yeah..dat's good idea thanks for giving information buddy.

Selected field value should store in variable

jagannalla — Thu, 21 Jul 2011 12:09:45 GMT

Hi ,

vMinA =if(wildmatch(GetFieldSelections(Group),'A''),min({<Group= {"A"}>}MinCure),'')

The above code is not working when i select A & B in the listbox at a time...

Selected field value should store in variable

swuehl — Thu, 21 Jul 2011 12:19:23 GMT

Hi Mr. Nokia,

I think you forgot the stars * in the search string. It must be '*A*'

like this

=if(wildmatch(GetFieldSelections(Group),'*A*'),min({<Group= {"A"}>}Value),'')

Stefan

Selected field value should store in variable

jagannalla — Thu, 21 Jul 2011 12:38:52 GMT

Sorry i forgot to give...But what is the use of * here..And also we need to give maximum size for GetFieldSelection. B'coz by default it holds 6 selections of listbox. So i given like this...

=if(wildmatch(GetFieldSelections(Group,'',50),'*A*'),min({<Group= {"A"}>}Value),'')

Thanks a lot Swuehl....

Selected field value should store in variable

swuehl — Thu, 21 Jul 2011 12:46:18 GMT

* is a wildcard, i.e. *A* would match either A, AB, BA, BAB, ....

Please note that Groupnames must be unique even in part, so if you use Group name A and AA, this will be problematic.

Stefan

Selected field value should store in variable

jagannalla — Thu, 21 Jul 2011 13:00:55 GMT

if data is as following if we get any problem when i write like this

v1=if(wildmatch(GetFieldSelections(Group,'',50),'*CureLaneP*'),min({<Group= {"CureLaneP"}>}Value),'')

v2=if(wildmatch(GetFieldSelections(Group,'',50),'*CureO2LevelAvgA*'),min({<Group= {"CureO2LevelAvgA"}>}Value),'')

CureLaneP

CureO2LevelAvgA

CureO2LevelMaxA

CureO2LevelMinA

CureTimeActualA

CureTimeHighIntensityA

CureTimeLowIntensityA

CureToDemoldTimeA

CureZone1TempAvgA

CureZone1TempMaxA

CureZone1TempMinA

CureZone2TempAvgA

CureZone2TempMaxA

CureZone2TempMinA

Selected field value should store in variable

swuehl — Thu, 21 Jul 2011 13:39:25 GMT

As long as you search in wildmatch with full group names, as you did in your two examples, this should be ok.

For example, if you would have an additional group CureLanePP and you would select only this one, expressions

v1=if(wildmatch(GetFieldSelections(Group,'',50),'*CureLaneP*'),min({<Group= {"CureLaneP"}>}Value),'')

v2=if(wildmatch(GetFieldSelections(Group,'',50),'*CureLanePP*'),min({<Group= {"CureLanePP"}>}Value),'')

would result in min values v1 and v2 set, while you would expect only the min value v2.

Thus, a group name shall not be a subset / part of another group name.

Stefan