Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

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
sunny_talwar

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) 

View solution in original post

4 Replies
sunny_talwar

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) 

Gysbert_Wassenaar

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
Specialist
Specialist
Author

Hello

It worked well......thanks  man

Digvijay_Singh

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.