topic table is effecting by date filters in QlikView

table is effecting by date filters

kunkumnaveen — Wed, 02 Mar 2016 11:07:32 GMT

Hello All,

i just want to known why my table is getting effect when i am changing the date filters,irrespective of the expression....

what i mean is i never mention date filter variable in my expression...

expression1: FirstSortedValue({<ROLE={'SELF_EVALUATOR'}>}TOTAL_SCORE, -DATE_OF_REVIEW )

expression2 : FirstSortedValue({<ROLE={'AUDITOR'}>}TOTAL_SCORE, -DATE_OF_REVIEW )

what i want is the table should remain same and not get effect even though the date filters are change

please find the attachment

thanks

naveen

Re: table is effecting by date filters

sunny_talwar — Wed, 02 Mar 2016 11:11:42 GMT

May be you need to tell your expression not to filter based on selection in date field:

FirstSortedValue({<ROLE={'SELF_EVALUATOR'}, ENSTEHDAT = >}TOTAL_SCORE, -DATE_OF_REVIEW)

FirstSortedValue({<ROLE={'AUDITOR'}, ENSTEHDAT = >}TOTAL_SCORE, -DATE_OF_REVIEW)

Re: table is effecting by date filters

Gysbert_Wassenaar — Wed, 02 Mar 2016 11:13:05 GMT

If you don't want selections in the date fields to influence your expressions then you need to overrule the selections in the set definition: FirstSortedValue({<MyDateField1=, MyDateField2=, ...etc, ROLE={'AUDITOR'}>}TOTAL_SCORE, -DATE_OF_REVIEW ). Replace MyDateField1=, MyDateField2=, ...etc, with the names of the date fields that shouldn't influence your expression.

Re: table is effecting by date filters

kunkumnaveen — Wed, 02 Mar 2016 11:14:58 GMT

Hello

It worked well......thanks man

Re: table is effecting by date filters

Digvijay_Singh — Wed, 02 Mar 2016 11:19:43 GMT

Qlikview is associate BI product, any change in any of the field selection will make changes in the whole application based on data model association built amongst fields.

The expression needs to be protected from change of selection of certain fields if required using set analysis like Fieldname=, as suggested by sunindia.