Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Ignore dimension when using first sorted value

Hi all,

I have an issue while attempting to ignore month selection when using first sorted value function.

My expected output is :

When Month is selected, Q1-Q4 should not be filtered.

 FSV1.PNG

Now when Month(Jul) is selected, Q2-Q4 is filtered out.

 FSV2.PNG

How can I achieved the result where:

When month is selected, Q1-Q4 still remains as well?

The expression looks like this:

FSV3.PNG

Thanks and regards,

Arthur Fong

Labels (1)
1 Solution

Accepted Solutions
Arthur_Fong
Partner - Specialist III
Partner - Specialist III
Author

Fixed. Thanks all.

FSV4.PNG

Current expression looks like this:

FSV5.PNG

View solution in original post

1 Reply
Arthur_Fong
Partner - Specialist III
Partner - Specialist III
Author

Fixed. Thanks all.

FSV4.PNG

Current expression looks like this:

FSV5.PNG