topic Conditional Mapping using multiple fields in QlikView https://community.qlik.com/t5/QlikView/Conditional-Mapping-using-multiple-fields/m-p/867275#M303384 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am new to Qlik View and am just trying to get around the way it works. I have a peculiar problem where I seek your help. I have a fact table that has among many other fields, few fields like Product Hierarchy, Application Hierarchy and Order Type. A point to be noted here is Product Hierarchy field runs into virtually millions of possible values. Now, I need to derive Product Category based on combination of conditions of the values of the three fields above. I can of course do this through a one big giant IF statement in my load, however, I rather prefer to try and define a mapping table for ease of ongoing maintenance. Can anyone suggest a solution please?</P><P></P><P>Thanks,</P><P>Pankaj</P></BODY></HTML> Mon, 04 May 2015 03:41:31 GMT 2015-05-04T03:41:31Z Conditional Mapping using multiple fields https://community.qlik.com/t5/QlikView/Conditional-Mapping-using-multiple-fields/m-p/867275#M303384 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am new to Qlik View and am just trying to get around the way it works. I have a peculiar problem where I seek your help. I have a fact table that has among many other fields, few fields like Product Hierarchy, Application Hierarchy and Order Type. A point to be noted here is Product Hierarchy field runs into virtually millions of possible values. Now, I need to derive Product Category based on combination of conditions of the values of the three fields above. I can of course do this through a one big giant IF statement in my load, however, I rather prefer to try and define a mapping table for ease of ongoing maintenance. Can anyone suggest a solution please?</P><P></P><P>Thanks,</P><P>Pankaj</P></BODY></HTML> Mon, 04 May 2015 03:41:31 GMT https://community.qlik.com/t5/QlikView/Conditional-Mapping-using-multiple-fields/m-p/867275#M303384 2015-05-04T03:41:31Z