topic Re: Ignoring certain rows in specific Tabrows in QlikView

Ignoring certain rows in specific Tabrows

Fri, 18 Oct 2013 15:09:07 GMT

Hello everyone,

I am currently having an issue in one of my tables. In my QV doc, I would like to filter out an entire row from the table. I am currently sorting by year (2008-2013) but I have another year in my excel for 2050. I do not want this year to appear in this specific tabrow but I still need it in my script for a separate tabrow. Any ideas?

Thanks!

Kevin

Re: Ignoring certain rows in specific Tabrows

MayilVahanan — Fri, 18 Oct 2013 15:14:46 GMT

Try like this

= If(Year <> 2050, Year) -> Expression in filter

Re: Ignoring certain rows in specific Tabrows

Fri, 18 Oct 2013 15:19:08 GMT

Am i creating a new expression in my table or adding it to an existing expression?

Re: Ignoring certain rows in specific Tabrows

jagan — Fri, 18 Oct 2013 15:27:01 GMT

Hi Kevin,

In expression try excluding the year by using Year-={2050}

=Sum({<Year-={2050}>} Sales)

Qlikview shows error near -=, by it works as expected.

Hope it helps u.

Regards,

Jagan.

Re: Ignoring certain rows in specific Tabrows

Fri, 18 Oct 2013 15:51:30 GMT

This eliminates the row when there is no data in it. But once I put data in for my other expressions the row appears again.

Re: Ignoring certain rows in specific Tabrows

jagan — Fri, 18 Oct 2013 15:59:01 GMT

Hi,

can u attach and come up with sample example. It helps in understanding the scenaio well

Regards,

Jagan.

Re: Re: Ignoring certain rows in specific Tabrows

Fri, 18 Oct 2013 16:12:46 GMT

Here is a sample. I would like to eliminate the 30000 from Net Sales.

Kevin

Re: Re: Re: Ignoring certain rows in specific Tabrows

jagan — Fri, 18 Oct 2013 16:21:21 GMT

Hi,

PFA file for solution

Regards,

Jagan.

Re: Ignoring certain rows in specific Tabrows

jagan — Sat, 19 Oct 2013 14:27:14 GMT

Hi,

Please close this post if your issue is solved, it helped others to solve this type of issues.

Regards,

Jagan.