Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

Calculated dimension

Can anybody help with this problem. I'm trying sp group customer into 3 categories based on revenue. i've made the following statement which works fine in expression, but won't work as a calculated dimension.

=If(Sum(if(CUSTOMER.CGRNO <> 'IA' And CUSTOMER.CGRNO <> 'KA' And CUSTOMER.CGRNO <> 'BA',  New_NET)) >= '90000', 'A',

if(Sum(if(CUSTOMER.CGRNO <> 'IA' And CUSTOMER.CGRNO <> 'KA' And CUSTOMER.CGRNO <> 'BA',  New_NET)) >= '30000' And Sum(if(CUSTOMER.CGRNO <> 'IA' And CUSTOMER.CGRNO <> 'KA' And CUSTOMER.CGRNO <> 'BA',  New_NET)) < '90000', 'B',

if(Sum(if(CUSTOMER.CGRNO <> 'IA' And CUSTOMER.CGRNO <> 'KA' And CUSTOMER.CGRNO <> 'BA',  New_NET)) < '30000', 'C', 0)))

I've come to the conclusion that it is the dual condition in line 2 and 3 there are causing the problem (Its a normal "and" sentence like in Excell). does anybody know how to get around this without editing the script ?

1 Reply
Not applicable

Re: Calculated dimension

sorry when posting it becomes line 3-5