topic Re: hide rows in QlikView

hide rows

Thu, 21 Nov 2013 21:24:03 GMT

Hi,

I have a strait table with one dimension. I need to hide rows from the table, based on expressions values which are calculated based on fields that different from the table’s dimension. Any ideas?

Thanks

Re: hide rows

MayilVahanan — Thu, 21 Nov 2013 21:35:08 GMT

Try with aggr() function in expression.

Re: hide rows

Thu, 21 Nov 2013 22:05:08 GMT

hi,

i have "store #" as the (only) dimension of the straight table. the expressions are sum(inventory) and sum(sales), were "inventory" and "sales" are fields. i need to hide all the rows with both sum(inventory)=0 and sum(sales)=0, and all the rows with "store #" <500. any idea how to achieve that?

thanks

Re: hide rows

MayilVahanan — Thu, 21 Nov 2013 22:12:09 GMT

For that, try like this

Exp1:

= if(Sum(Sales) <> 0 and Sum(Inventory) <> 0 and "store #" < 500, Sum(Sales))

Exp2:

= if(Sum(Sales) <> 0 and Sum(Inventory) <> 0 and "store #" < 500, Sum(Inventory))

Re: hide rows

jagan — Fri, 22 Nov 2013 03:04:46 GMT

Hi Danny,

Try like this

Exp1:

= Sum({<[store #]={'< 500'} >}Sales)

Exp2:

= Sum({<[store #]={'< 500'} >}Inventory)

and then in Presentation tab select "Suppress zero values" option.

Regards,

Jagan.