Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
apthansh
Contributor

Text object Action

I have 2 list boxes - Status and Type.

Status

Active

Inactive

Type

Rent

Non-Rent

When I click on the text object I want everything to be selected from Status and Type  except Inactive.Is this doable ?


Thank you much.

1 Reply

Re: Text object Action

go to action tab of text object, add two actions like below

1) To select status

Add action-> Select in Field ->

field : Status

value : '(' & concat(DISTINCT chr(39) & if(Status<>'Inactive',Status) & chr(39),',') &')'


2) To select Type

Add action-> Select in Field ->

field : Type

value : '(' & concat(DISTINCT chr(39) & Type & chr(39),',') &')'