Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use field in db for static colum

I have a problem that seems easy to solve but i can't make it...

For a pivot table i use an field in sql db "anoVtaCab"... Then in the filter i have all the years (2010 - 2011 - 2012 - 2013 - 2014 - 2015 - 2016)... When i selected for example year 2013 the table only leave the 2013 colum, but i dont want this ... i want the columns on this table (only) to ignore the selection... how can i do?

1 Solution

Accepted Solutions
sunny_talwar

Try this:

Sum({<anoVtaCab>} sales)

Now any selections made in anoVtaCab field won't reflect on the chart anymore

View solution in original post

10 Replies
sunny_talwar

What expression are you using? If you want to ignore all selections, you can add {1}. If you are looking to ignore specific selections, you can list them out like this {<FieldName1, FieldName2, FieldName3>}

Not applicable
Author

Im just using the year field anoVtaCab... its only contain the year...

sunny_talwar

Where are you using this? Can you share an image to clarify what you have?

Not applicable
Author

vtacab.png

here, i use the year as a colum, but i dont want this colum to be afected by a filter

sunny_talwar

what is your expression here?

Not applicable
Author

only "anoVtaCab"

sunny_talwar

Isn't anoVtaCab your dimension which is just a name for Year??? Or is this truly an expression? I am looking for the measure? If it is, then try this

Only({<Year>} anoVtaCab)

Not applicable
Author

Measure is SUM(sales), rows is vendors, and colums is just anoVtaCab

sunny_talwar

Try this:

Sum({<anoVtaCab>} sales)

Now any selections made in anoVtaCab field won't reflect on the chart anymore