Discussion board where members can get started with QlikView.
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,
May be this?
=if(Month <> 'Jan',Month)
Like i have excluded Jan in Month Dimension.
Thanks for your replay,
i want to exclude the value from this field when the sheet is activated.
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
Hope this helps.