Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Contributor

set analysis with 2 different data types

Hi,

I'm having a set analysis with alternate sates where I have show data of 2 different data types, Both number and string

Here is what i'm using,
MaxString({[state1]<field1={1}>}ir02.kpi_value)+sum({[state1]<field1={2}>}ir02.kpi_value)
since data is of 2 different data types set analysis is not performing OR operation.


Other way i'm trying is using if condition but not sure how to use alternate states in if condtion.


Any suggestions?