10 Replies Latest reply: Apr 5, 2016 5:42 AM by Sunny Talwar

# Filter table with single product

In qlik sense, I need to show data for single product in table format without using filter pane.

• ###### Re: Filter table with single product

Hi,

You can use the set analysis to show the data for one product.

Look at the link for more help.

Set Analysis: syntaxes, examples

Learning Set Analysis from Scratch

Regards,

Kaushik Solanki

• ###### Re: Filter table with single product

Use set analysis for that...

Something like below..

SUM({<Country = {'France'}>}Sales)

• ###### Re: Filter table with single product

If I have calculation in my measure that is (current value - previous value / previous value) then how should I use set analysis for that?

• ###### Re: Filter table with single product

What exactly is your expression? and what exact filter you want to apply?

• ###### Re: Filter table with single product

I need to show values for expression (Sum(CURR_ACTUAL) - SUM(PREV_ACTUAL))/SUM(PREV_ACTUAL) based upon product 1 in table. Similarly I have three columns in same table with some calculations, need to show all these three columns based upon product 1.

• ###### Re: Filter table with single product

(Sum({<Product = {'Product 1'}>}CURR_ACTUAL) - SUM({<Product = {'Product 1'}>}PREV_ACTUAL))/SUM({<Product = {'Product 1'}>}PREV_ACTUAL)

• ###### Re: Filter table with single product

May be this:

(Sum({<Product = {'Product 1'}>} CURR_ACTUAL) - SUM({<Product = {'Product 1'}>} PREV_ACTUAL))/SUM({<Product = {'Product 1'}>} PREV_ACTUAL)

• ###### Re: Filter table with single product

Hi Nitin,

Make use of Set analysis to achieve this. Also note that once the set analysis is used on a specific field, it cannot be filtered using that field anymore.

• ###### Re: Filter table with single product

Thanks a lot ton, it worked.....