Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
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.
Hello
It worked well......thanks man
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.