Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

ignore selections in if Statement

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. 

2 Solutions

Accepted Solutions
Highlighted
Creator
Creator

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

View solution in original post

Highlighted
Partner
Partner

Use
ONLY({1} BUKET_MONTHLYTIMETABLE ) = instead of
BUKET_MONTHLYTIMETABLE =
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

2 Replies
Highlighted
Creator
Creator

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

View solution in original post

Highlighted
Partner
Partner

Use
ONLY({1} BUKET_MONTHLYTIMETABLE ) = instead of
BUKET_MONTHLYTIMETABLE =
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post