Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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...
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Partner
Partner

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.

Highlighted
Contributor II
Contributor II

Thank! It really helped me.)
Highlighted
Partner
Partner

Hi!

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

Regards,

Jaime.