topic if to set analysis in QlikView

if to set analysis

jasonseril — Mon, 14 Dec 2009 07:12:05 GMT

hi to all,

can anybody change the expression below to set analysis? this is making the document's performance slow,

(

????='???' and ??????='??', num(sum({$<CityGroup1 = {'??'} >} CUST_CNT)/10000, '#,##0'),

if(????='???' and ??????='??', num(sum({$<CityGroup1 = {'??'} >} CUST_CNT)/sum({$<CityGroup1 = {'*'} >} CUST_CNT)*100,'#.##') & ' %',

thanks in advance, more power,

jason

if to set analysis

Miguel_Angel_Baeyens — Mon, 14 Dec 2009 15:50:33 GMT


jasonseril wrote:????='???' and ??????='??',

Hi Jason,

Are green values variable names o fields? In this second case, try something like

Num(Sum({ $< CityGroup1 = {'...'}, green={'blue'}, green={'blue'} > }))

Unfortunately, quoting your charset gives me some wrong characters in the reply, so change my "green" for your expressions in green and "blue" for yours in blue.