Can any one please guide on how to create dimension in straight table independent of any changes in filter.

[Anonymous]

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.

[rubenmarin]

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.

[vinieme12]

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)

[vinieme12]

Refer this thread

Set Analysis: syntaxes, examples