Ignoring certain rows in specific Tabrows

[#1]

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

[MayilVahanan]

Hi

Try like this

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

[#3]

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

[jagan]

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.

[#5]

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.

[jagan]

Hi,

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

Regards,

Jagan.

[#7]

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

Kevin

[jagan · Accepted solution]

Hi,

PFA file for solution

Regards,

Jagan.

[jagan]

Hi,

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

Regards,

Jagan.