Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ramcena306
Contributor

How to Exclude a single value in a dimension for a particular report ?

Hello All,

i have a multibox and it is a linked object, and i want to exclude particular value in a dimension in that multibox in a single report.

any suggestions ?

Thanks & Best Regards,

Ramesh

3 Replies
shiveshsingh
Honored Contributor

Re: How to Exclude a single value in a dimension for a particular report ?

May be this?

=if(Month <> 'Jan',Month)

Like i have excluded Jan in Month Dimension.

ramcena306
Contributor

Re: How to Exclude a single value in a dimension for a particular report ?

Hello Shivesh,

Thanks for your replay, 

i want to exclude the value from this field when the sheet is activated.

 

Regards,

Ramesh.

shiveshsingh
Honored Contributor

Re: How to Exclude a single value in a dimension for a particular report ?

Hello Ramcena

Do one thing, create one variable and set it's value to 0.

Now create a trigger which set variable value to 1 on sheet activation and also create a trigger that resets it's value to 0 again on sheet leave.

Now you can set a conditional dimension like

=if(vTest=1,if(Company<>'C1',Company))

 

Hope this helps.

Community Browser