Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Ksenia_Vo
New 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.

Tags (3)
4 Replies
Partner
Partner

Re: Expression

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...
???
Celebrating my 300 accepted solution in the Qlik Community
???
Partner
Partner

Re: Expression

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
New Contributor II

Re: Expression

Thank! It really helped me.)
Partner
Partner

Re: Expression

Hi!

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

Regards,

Jaime.