Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

jasonseril
Contributor

if to set analysis

hi to all,

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

if

(

(

(

????='???' 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



1 Reply
MVP
MVP

if to set analysis


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.


Community Browser