topic Help me on this!!! in QlikView

Help me on this!!!

Thu, 04 Apr 2013 05:06:40 GMT

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

Re: Help me on this!!!

sushil353 — Thu, 04 Apr 2013 05:48:45 GMT

Hello,

you can use set analysis.

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

otherwise please explain your issue/requirement.

HTH

Sushil

Re: Help me on this!!!

Siva_Sankar — Thu, 04 Apr 2013 05:50:33 GMT

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

Re: Help me on this!!!

advait_thakur — Thu, 04 Apr 2013 05:56:13 GMT

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!!!

kaushiknsolanki — Thu, 04 Apr 2013 05:57:31 GMT

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

Re: Help me on this!!!

Thu, 04 Apr 2013 09:44:03 GMT

Thanks sushil