Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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")
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 ) )
or
If( ( Name Like Fav.Apple & '*' ) OR ( Fav.Apple Like Name & '*' ) , Sum( cost ) )
if you have a straigth table with 3 dimension, Fruit Name Fav. Apple try with expression
if([Name]=[Fav. Apple]), sum(cost))
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
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 ) )
or
If( ( Name Like Fav.Apple & '*' ) OR ( Fav.Apple Like Name & '*' ) , Sum( cost ) )
try
if(index(Name, [Fav. Apple]) or index( [Fav. Apple],Name),sum(price))
Thanks! This seems to work for me!