Deselect in bar chart

yoganantha321 — Wed, 25 Nov 2020 16:16:04 GMT

I have used the following expression and one field as dimension in bar chart.

Dimension:

Field 1: =IF( MonthlyWorkHour>7, 'Occupied', IF( MonthlyWorkHour>3 and MonthlyWorkHour<8, 'Partially Occupied', IF( MonthlyWorkHour<4, 'Available' )))

Field 2: Project Name

Expression: count (Employee Id)

I got the output as

When I selected partially occupied, the single bar highlights and again selected it bring backs to the original position like below

but while selecting on the other two namely Occupied and Available I cannot get back to the original status as shown in first image

Regards,

Yoganantha Prakash G P

Re: Deselect in bar chart

Anonymous — Wed, 22 Mar 2017 10:02:07 GMT

hi,

Better you can use this expression as a field of table and place it in any dimensional or fact table IF( MonthlyWorkHour>7, 'Occupied', IF( MonthlyWorkHour>3 and MonthlyWorkHour<8, 'Partially Occupied', IF( MonthlyWorkHour<4, 'Available' ))) then it will change according what you select

topic Deselect in bar chart in QlikView

Deselect in bar chart

Re: Deselect in bar chart