topic How two expressions could be applied in set expression with < along with other dimention! in QlikView

How two expressions could be applied in set expression with < along with other dimention!

nevilledhamsiri — Wed, 25 Nov 2020 16:16:04 GMT

I need following conditions to be satisfied through a set expression

Dimensions

PRD_CODE

BRANCH

EXPRESSIONS

GROSS PREMIUM

NET PREMIUM

I wrote the set expression as follows!

SUM({<PRD_CODE={'KK','PP'},BRANCH={'RA'}, GROSS PREMIUM={">NET PREMIUM"}>} SALES)

I require when PRD_CODE=kk,pp, and Branch = RA, GROSS PREMIUM > NET PREMIUM, the sales!

Please see the error & the place

Thanks for early reply

Neville

Anil_Babu_Samineni — Sun, 29 Oct 2017 15:39:41 GMT

I always prefer to create in script like

If(gross>net, 1,0) as flag then in Set analysis you can write flag ={1}

Or else try this

SUM({<PRD_CODE={'KK','PP'},BRANCH={'RA'}, GROSS PREMIUM={"= GROSSPREMIUM >NET PREMIUM"}>} SALES)

lironbaram — Sun, 29 Oct 2017 15:44:51 GMT

because set analysis is like making selection in the app

your last condition isn't going to work

you'll need something like

SUM({<PRD_CODE={'KK','PP'},BRANCH={'RA'}>} if(GROSS PREMIUM>NET PREMIUM,SALES))

this expressions assumes that gross premium and net premium are values in a record and not aggregation functions