topic Re: issues with current selection in QlikView

issues with current selection

Anonymous — Tue, 21 Feb 2017 08:47:23 GMT

I have a table which displays a measure for 2015 and 2016 in two columns

whatever year user selects always 2015 and 2016 data should get displayed in the chart.

i have hardcoded year in the both expression. it should not affected by year selection. Month is my dimention.

I am giving year=2015 inside 2015 expression and year=2016 inside 2016 expression. and year= , but when i select 2016 then data for 2016 shows correct but when i select 2015 2016 becomes zero.

Re: issues with current selection

zhadrakas — Tue, 21 Feb 2017 08:52:20 GMT

i think year=2016 overrides year=.

you can use an Expression like this to ignore all selections

sum({1} if(year=2016, YOURFIELD))

Re: issues with current selection

Anonymous — Tue, 21 Feb 2017 09:19:53 GMT

but if i use {1} then it will ignore all the selection, i want it to get affected by other dimensions except year.

Re: issues with current selection

Tue, 21 Feb 2017 09:23:13 GMT

Try this

SUM({<YEAR={2015,2016}>}SALES)

Re: issues with current selection

sdmech81 — Tue, 21 Feb 2017 09:36:13 GMT

This one u did:

Sum({<Year={'2015'}>}Your_field)

Sum({<Year={'2016'}>}Your_field)

Plss try above..I agree with sasi

Re: issues with current selection

sasikanth — Tue, 21 Feb 2017 10:07:30 GMT

HI,

By default if you hard code any value of a field then corresponding field related selections will not apply on chart.

Below expressions work,

=Sum({<YEAR={'2015'}>}Sales)

=Sum({<YEAR={'2016'}>}Sales)

Let us know if not