Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In qlik sense, I need to show data for single product in table format without using filter pane.
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
Use set analysis for that...
Something like below..
SUM({<Country = {'France'}>}Sales)
If I have calculation in my measure that is (current value - previous value / previous value) then how should I use set analysis for that?
What exactly is your expression? and what exact filter you want to apply?
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.
(Sum({<Product = {'Product 1'}>}CURR_ACTUAL) - SUM({<Product = {'Product 1'}>}PREV_ACTUAL))/SUM({<Product = {'Product 1'}>}PREV_ACTUAL)
May be this:
(Sum({<Product = {'Product 1'}>} CURR_ACTUAL) - SUM({<Product = {'Product 1'}>} PREV_ACTUAL))/SUM({<Product = {'Product 1'}>} PREV_ACTUAL)
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.
Thanks a lot ton, it worked.....