topic Re: Expression in QlikView

Expression

Ksenia_Vo — Mon, 06 May 2019 13:53:30 GMT

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.

Re: Expression

Vegar — Mon, 06 May 2019 14:31:57 GMT

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%20Chart%20Ranking%20functions.htm

Re: Expression

jaibau1993 — Mon, 06 May 2019 14:51:44 GMT

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.

Re: Expression

Ksenia_Vo — Wed, 15 May 2019 12:02:48 GMT

Thank! It really helped me.)

Re: Expression

jaibau1993 — Wed, 15 May 2019 12:43:42 GMT

Hi!

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

Regards,

Jaime.