Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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.

3 Replies
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
Champion III
Champion III

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)



Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

Refer this thread

Set Analysis: syntaxes, examples

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.