nested IF based on variable outputs

Wed, 25 Nov 2020 16:16:04 GMT

Im trying to get the max number of days based on criteria set by a user selected data using variables and input boxes, I have already got an individual straight table that will give the max days based on one criteria, but now need based on many

example of my code to do this is:

=if(months=POI and project=DRTYPE and [country]=LOC, max(compdays)) - Just returns NULL though expression says OK

So in this scenario, user selects number of months required, then the project type and then the location, based on this the result should be the maximum days

Only way I can get max days correctly is a straight tables with those fields, and then a separate statistic box, which is OK, but I have another text box that computes the max days by a cost, so this way the user would have to manually key the max days to get cost, which is then subject to input error

Using Qlikview

Thanks

Kev

Re: nested IF based on variable outputs

vinieme12 — Thu, 24 Aug 2017 14:43:27 GMT

try

= Max( if(months=POI and project=DRTYPE and [country]=LOC, compdays ) )

also what is the definition of these variables? are they defined with a preceding equal sign?

also try $ expansion so the variables evaluate

Max( if(months=$(POI) and project=DRTYPE and [country]=LOC, compdays ) )

topic nested IF based on variable outputs in QlikView

nested IF based on variable outputs

Re: nested IF based on variable outputs