topic Need help on braces in QlikView

Need help on braces

bharatkishore — Wed, 13 Jul 2016 16:49:23 GMT

Hi All i have the following expression which is working fine,

=if((((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]))

Avg(TOTAL {<Campaign = {"=Rank(((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]))) <= 10"}>} Aggr((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]), Campaign)))/

>0.10,'qmem://<bundled>/BuiltIn/led_g.png',

if((((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]))

<-0.10,'qmem://<bundled>/BuiltIn/led_r.png','qmem://<bundled>/BuiltIn/led_y.png'))

But now i need to insert =sum([Unique Clickthroughs])/sum([Unique Opens]) instead of Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]..

Am struggling from hour to find the issue please help me in inserting those fields.

I kept dimension limits and this expression is working fine but for other expressions it is not working pls help

Re: Need help on braces

sunny_talwar — Wed, 13 Jul 2016 16:54:12 GMT

May be this:

=if(((Sum([Unique Clickthroughs])/Sum([Unique Opens]))

Avg(TOTAL {<Campaign = {"=Rank((Sum([Unique Clickthroughs])/Sum([Unique Opens]))) <= 10"}>} Aggr(Sum([Unique Clickthroughs])/Sum([Unique Opens]), Campaign)))/

Avg(TOTAL {<Campaign = {"=Rank((Sum([Unique Clickthroughs])/Sum([Unique Opens]))) <= 10"}>} Aggr(Sum([Unique Clickthroughs])/Sum([Unique Opens]), Campaign))

>0.10,'qmem://<bundled>/BuiltIn/led_g.png',

if(((Sum([Unique Clickthroughs])/Sum([Unique Opens]))

Avg(TOTAL {<Campaign = {"=Rank((Sum([Unique Clickthroughs])/Sum([Unique Opens]))) <= 10"}>} Aggr(Sum([Unique Clickthroughs])/Sum([Unique Opens]), Campaign)))/

Avg(TOTAL {<Campaign = {"=Rank((Sum([Unique Clickthroughs])/Sum([Unique Opens]))) <= 10"}>} Aggr(Sum([Unique Clickthroughs])/Sum([Unique Opens]), Campaign))

<-0.10,'qmem://<bundled>/BuiltIn/led_r.png','qmem://<bundled>/BuiltIn/led_y.png'))

Re: Need help on braces

bharatkishore — Wed, 13 Jul 2016 17:13:24 GMT

Thanks a lot Sunny.. But i have 2 expressions like total contact and open rate .. the images are working fine for total contact top 10 and not working correctly fr open rate.. When i disable this expression it is working fine.. Please help me how do i get this..