topic set analysis with 2 different data types in QlikView https://community.qlik.com/t5/QlikView/set-analysis-with-2-different-data-types/m-p/1374576#M419708 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm having a set analysis with alternate sates where I have show data of 2 different data types, Both number and string</P><P>Here is what i'm using,<BR /> MaxString({[state1]&lt;field1={1}&gt;}ir02.kpi_value)+sum({[state1]&lt;field1={2}&gt;}ir02.kpi_value)<BR />since data is of 2 different data types set analysis is not performing OR operation.</P><P><BR />Other way i'm trying is using if condition but not sure how to use alternate states in if condtion.</P><P><BR />Any suggestions?</P></BODY></HTML> Mon, 30 Oct 2017 09:11:24 GMT kmswetha 2017-10-30T09:11:24Z set analysis with 2 different data types https://community.qlik.com/t5/QlikView/set-analysis-with-2-different-data-types/m-p/1374576#M419708 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm having a set analysis with alternate sates where I have show data of 2 different data types, Both number and string</P><P>Here is what i'm using,<BR /> MaxString({[state1]&lt;field1={1}&gt;}ir02.kpi_value)+sum({[state1]&lt;field1={2}&gt;}ir02.kpi_value)<BR />since data is of 2 different data types set analysis is not performing OR operation.</P><P><BR />Other way i'm trying is using if condition but not sure how to use alternate states in if condtion.</P><P><BR />Any suggestions?</P></BODY></HTML> Mon, 30 Oct 2017 09:11:24 GMT https://community.qlik.com/t5/QlikView/set-analysis-with-2-different-data-types/m-p/1374576#M419708 kmswetha 2017-10-30T09:11:24Z