Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

table is effecting by date filters

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 



1 Solution

Accepted Solutions

Re: table is effecting by date filters

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) 

4 Replies

Re: table is effecting by date filters

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

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.


talk is cheap, supply exceeds demand
kunkumnaveen
Contributor III

Re: table is effecting by date filters

Hello

It worked well......thanks  man

Digvijay_Singh
Honored Contributor III

Re: table is effecting by date filters

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.

Community Browser