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: 
Ksenia_Vo
Contributor II
Contributor II

Expression

Hello! I have a table with 4 columns, two dimensions and two expressions. There is a field "№", I need to write a formula in the expression that could show the numbers in the format "1-4", if in another field the values under these numbers match. Attaching an example of how it should work.

4 Replies
Vegar
MVP
MVP

Consider looking into the rank() function, it can present rank as you describe.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Examples%20of%2...
jaibau1993
Partner - Creator III
Partner - Creator III

Hi!

You should use the "Class" function (Qlik Help) but it is not quite aesthetic so you may create your own classificator. Check the attached file where I use Class function and create my own expression.

Bests,

Jaime.

Ksenia_Vo
Contributor II
Contributor II
Author

Thank! It really helped me.)
jaibau1993
Partner - Creator III
Partner - Creator III

Hi!

If you consider the issue solved please please mark the correct answer as solution (mine, Vegar's or both).

Regards,

Jaime.