ignore selections in if Statement

[ebrahimaljafri]

hi qlikers 

i am using pie chart to present a bucket range of time and i have applied each range a color within color and legend using color by expression . 

if i am using set analysis i would use 1 within set analysis and will ignore all selections but i am using if statement and can not use 1 in it.

please help. 

[jerryyang756 · Accepted solution]

Try this...exclude selections in SELECTION1=,SELECTION2=

if( Only({< SELECTION1=,SELECTION2= >} BUKET_MON'I‘HLYTIMETABLE)='less Than 7' , '#66b699',
if( Only({< SELECTION1=,SELECTION2= >} BUKET_MON'I‘HLYTIMETABLE)='7-10','#ffff4d',
if( Only({< SELECTION1=,SELECTION2= >} BUKET_MON'I‘HLYTIMETABLE)='More Than 10', '#ff4d4d'
)))

or with {1} to exclude all selections

if( Only({1} BUKET_MON'I‘HLYTIMETABLE)='less Than 7' , '#66b699',
if( Only({1} BUKET_MON'I‘HLYTIMETABLE)='7-10','#ffff4d',
if( Only({1} BUKET_MON'I‘HLYTIMETABLE)='More Than 10', '#ff4d4d'
)))

[Vegar · Accepted solution]

Use
ONLY({1} BUKET_MONTHLYTIMETABLE ) = instead of
BUKET_MONTHLYTIMETABLE =