Filter table with single product

[#1]

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

[kaushiknsolanki]

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

[MK_QSL]

Use set analysis for that...

Something like below..

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

[#4]

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

[sunny_talwar]

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

[#6]

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.

[MK_QSL]

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

[sunny_talwar]

May be this:

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

[reddy-s]

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.

[#10]

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