topic ignore selections in if Statement in QlikView

ignore selections in if Statement

ebrahimaljafri — Wed, 14 Nov 2018 05:57:19 GMT

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.

Re: ignore selections in if Statement

jerryyang756 — Wed, 14 Nov 2018 06:33:24 GMT

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'
)))

Re: ignore selections in if Statement

Vegar — Wed, 14 Nov 2018 06:23:17 GMT

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