Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
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?

Tags (4)
1 Solution

Accepted Solutions

Re: Use field in db for static colum

Try this:

Sum({<anoVtaCab>} sales)

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

10 Replies

Re: Use field in db for static colum

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

Re: Use field in db for static colum

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

Re: Use field in db for static colum

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

Not applicable

Re: Use field in db for static colum

vtacab.png

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

Re: Use field in db for static colum

what is your expression here?

Not applicable

Re: Use field in db for static colum

only "anoVtaCab"

Re: Use field in db for static colum

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

Re: Use field in db for static colum

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

Re: Use field in db for static colum

Try this:

Sum({<anoVtaCab>} sales)

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