Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Help me on this!!!

Hi all,

Can anyone help me to make filter in table box?

For example i try with  this expression Par_flag='N'

But it 's not working

Please let me know about this.I'm new to this tool

Thanks,

Thiru

1 Solution

Accepted Solutions
sushil353
Honored Contributor II

Re: Help me on this!!!

Hello,

you can use set analysis.

something like: =sum({<Par_flag={'N'}>}values)

otherwise please explain your issue/requirement.

HTH

Sushil

5 Replies
sushil353
Honored Contributor II

Re: Help me on this!!!

Hello,

you can use set analysis.

something like: =sum({<Par_flag={'N'}>}values)

otherwise please explain your issue/requirement.

HTH

Sushil

Siva_Sankar
Honored Contributor

Re: Help me on this!!!

Its not possible to use an expression to filter in the table box object. But you can use a straight table chart instead, maybe with a calculated dimension =if(Par_flag= 'N', Not) Then your can add dimensions or expression as you like. Or you can also use set analysis in all your expressions to limit the results, for example, use flag as dimension and Regards, siva

advait_thakur
Contributor III

Re: Help me on this!!!

Hi Thiru,

First of all you cannot take any condition on your Expression in Table Box.

You can choose only Fields in Table Box.

Please let me know what exactly you want to achieve.

Thanks

Advait

Re: Help me on this!!!

Hi,

     Expressions are not allowed in Table Box.

     Instead you can use the straight table. Straight table allows you to put expression.

Regards,

Kaushik Solanki

Not applicable

Re: Help me on this!!!

Thanks sushil

Community Browser