If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I am trying to create a dimension that is derived from 3 fields and i am having a difficult time.
There should end up being three values-
This is the SQL I use currently which works as expected -
case when M =1 then 'Mar'
when LeadSource = 'C' or LeadSource='P'
or M = 0
not in (,'Direct','Sales','Brought',') then 'Partner'
else 'Rep' end
Here is what I have now in my app, but I cant get this worked out ----
If(M = '1', 'Mar',
If(M = '0','Partner'
If(Match(Dbb,'Partner') = 1 , 'Partner','Rep Created')))
This only returns 'Mar"
Any help pointing me in the right direction would be greatly appreciated.
See if this works..
There may be better way to do this..but try this:
if( M=1, 'Mar',
if ( ( LeadSource='C' or LeadSource='P' or M=0 ) or ( Dbb <> 'Direct' and Dbb <> 'Sales' and Dbb <> 'Brought') ,'Partner','Rep')
This looks like it works.
There is a comma after the first "Leadsource" that I dropped assuming that was a typo.
I will check this again to be sure and mark as correct.
Thank you. I have not been able to try all the suggestions yet but thanks to all for the speedy input!!
Feel free to use any of the expressions, but just as a suggestion... it requires less typing and makes the code looks nicer using Match() or WildMatch() functions