topic Re: Possible to have conditional expressions when two dimensions match in QlikView

Possible to have conditional expressions when two dimensions match

Mon, 15 Jun 2015 18:19:07 GMT

Hi all,

I'm a newbie with qlik so bare with me...

Is it possible to have a conditional expression when two dimensions match? I have the following table

Fruit Name Fav. Apple cost

Apple Fiji Gala $1

Apple Gala Gala $3

Apple Granny Smith Gala $5

Apple Red Delicious Gala $2

So in my case I want to only show the sum of the cost when [Fav. Apple] = [Name], or in this case Gala=Gala.

Obviously the data is oversimplified, but is this possible?

I have tried:

if(wildmatch([Name],[Fav. Apple]), sum(cost), "False")

maxgro — Mon, 15 Jun 2015 19:12:15 GMT

if you have a straigth table with 3 dimension, Fruit Name Fav. Apple try with expression

if([Name]=[Fav. Apple]), sum(cost))

Mon, 15 Jun 2015 19:20:14 GMT

Thanks Massimo.

How would I go about this if the [Name] and [Fav. Apple] are not an exact match?

i.e. Name= Gala, Fav. Apple = Gala, inc

petter — Mon, 15 Jun 2015 19:36:52 GMT

You could use the Like operator:

Name Like 'Gala*'

So Like replace the equal sign and the * is a wildcard meaning any number of characters:

If( Name Like Fav.Apple & '*' , Sum( cost ) )

If( ( Name Like Fav.Apple & '*' ) OR ( Fav.Apple Like Name & '*' ) , Sum( cost ) )

maxgro — Mon, 15 Jun 2015 19:38:56 GMT

try

if(index(Name, [Fav. Apple]) or index( [Fav. Apple],Name),sum(price))

Mon, 15 Jun 2015 20:26:44 GMT

Thanks! This seems to work for me!