topic Re: Need help to write an expression ? in QlikView

Need help to write an expression ?

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

Hi All,

Please kindly see the image attached.

The Non User calculation is done in second chart -

if([No. of Policy Users Sold]= 0,[Open Users]-[No. of Policy Users Sold],0)

so , if no policy sold then non user is [open user] - [no.of policy sold]

the second chart is working correctly as there is dimension Dealership in the chart .

But , for the first chart ,

there is no dealership dimension . Thus the Non user is not working correctly .

if I used the expression -

if([No. of Policy Users Sold]= 0,[Open Users]-[No. of Policy Users Sold],0) the result is showing 0 as there are not breaks down in dealership dimension.

Please assist me in writing the expression.

Many Thanks,

Re: Need help to write an expression ?

kaushiknsolanki — Mon, 29 Jan 2018 09:25:11 GMT

Try this.

Sum( Aggr(if([No. of Policy Users Sold]= 0,[Open Users]-[No. of Policy Users Sold],0),Delearship))

Regards,

Kaushik Solanki

Re: Need help to write an expression ?

shiveshsingh — Mon, 29 Jan 2018 09:52:59 GMT

plz try this in calculated dimension

Aggr(if([No. of Policy Users Sold]= 0,[Open Users]-[No. of Policy Users Sold],0),Delearship)