topic Re: set analysis with getfield selection in QlikView

set analysis with getfield selection

rdsuperlike — Tue, 02 Jun 2015 18:41:25 GMT

@I want to insert getffieldselection in the below set analysis. What would be the current syntax?

if(Product = getfieldselection(Product))

=Num(max( {$<Fruits= {Apple} >} [Days of transport Pre] ),'#.0')

Re: set analysis with getfield selection

ronald_gdi — Tue, 02 Jun 2015 18:49:27 GMT

Create a new variable and put the code:

if(Product = getfieldselection(Product))

Than put de variable into the expression

Num(max( {$<Fruits= {$(variable)} >} [Days of transport Pre] ),'#.0')

Kind Regads!

Re: set analysis with getfield selection

marcus_sommer — Tue, 02 Jun 2015 18:50:47 GMT

Try: =Num(max( {$<Fruits= {"$(=getfieldselections(Product))"} >} [Days of transport Pre] ),'#.0')

- Marcus

Re: set analysis with getfield selection

rdsuperlike — Tue, 02 Jun 2015 18:54:22 GMT

Posted the app too. I want the fruits = apple and also only the relevant fruits should come up based on the product selected.hence I was asking for both the conditions

Re: set analysis with getfield selection

rdsuperlike — Tue, 02 Jun 2015 18:54:37 GMT

Posted the app too. I want the fruits = apple and also only the relevant fruits should come up based on the product selected.hence I was asking for both the conditions

Re: set analysis with getfield selection

pratap6699 — Tue, 02 Jun 2015 19:09:12 GMT

=max({<fruits={"=getfieldselections(product)"}>}[Days of transport pre])

Re: set analysis with getfield selection

rdsuperlike — Tue, 02 Jun 2015 19:13:27 GMT

I tried putting it in the app. But its not working.

I want to give input box for users to change the values for each fruit's pre and post days

Re: set analysis with getfield selection

Anonymous — Thu, 20 Dec 2018 10:09:27 GMT

Try

=Num(max( {$<Fruits=P(Fruits) >} [Days of transport Pre] ),'#.0')