Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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.