Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Can any one please guide on how to create dimension in straight table independent of any changes in filter in Qlik sense.
For more detail explanation i have attached the sample excel file.
Hi Vivek, you can try checking the option to 'Show all values' in Dimensions tab, and also uncheck the option to 'Supress zero values' in Presentation tab.
to ignore selections of a particular field just specify that field in the Set Expression
for example in below expression, any selections made in the Region field will not affect the straight table
SUM( {< Region=, Year={2017} >} SALES)
If you want to ignore ALL Selections just add a modifier 1 as below
SUM( { 1< Year={2017} >} SALES)
Refer this thread
Set Analysis: syntaxes, examples