topic Re: Set analysis error in QlikView

Set analysis error

QSense — Wed, 14 Nov 2012 17:04:04 GMT

In expression ,I have a set analysis like

count({<IsApprovedForPrint={’E’}, Durum!={'Deleted'),Durum!={'Degistirildi'}>} ID)

It gives error maybe ı just used != or <> for not equal but bot of them do not work

Thanks

shree909 — Wed, 14 Nov 2012 17:31:11 GMT

Try this

count({<IsApprovedForPrint={’E’}, Durum<>{'Deleted','Degistirildi'}>} ID)

QSense — Wed, 14 Nov 2012 17:45:32 GMT

=count({<IsApprovedForPrint={"E"}, Durum={"*"}>} ID) -count({<IsApprovedForPrint={"E"}, Durum={"Deleted","Degistirildi"}>} ID)