topic Re: Use field in db for static colum in App Development

Use field in db for static colum

Thu, 08 Dec 2016 02:58:45 GMT

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?

Re: Use field in db for static colum

sunny_talwar — Thu, 08 Dec 2016 03:02:42 GMT

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>}

Re: Use field in db for static colum

Thu, 08 Dec 2016 03:06:27 GMT

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

Re: Use field in db for static colum

sunny_talwar — Thu, 08 Dec 2016 03:09:15 GMT

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

Re: Use field in db for static colum

Thu, 08 Dec 2016 03:12:01 GMT

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

sunny_talwar — Thu, 08 Dec 2016 03:13:42 GMT

what is your expression here?

Re: Use field in db for static colum

Thu, 08 Dec 2016 03:15:52 GMT

only "anoVtaCab"

Re: Use field in db for static colum

sunny_talwar — Thu, 08 Dec 2016 03:17:32 GMT

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)

Re: Use field in db for static colum

Thu, 08 Dec 2016 03:27:40 GMT

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

Re: Use field in db for static colum

sunny_talwar — Thu, 08 Dec 2016 03:29:31 GMT

Try this:

Sum({<anoVtaCab>} sales)

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

Re: Use field in db for static colum

Thu, 08 Dec 2016 03:34:36 GMT

Thanks, that works!