parttition equivalent to qlikview

[vipingarg23]

CASE

            WHEN

                ROW_NUMBER()

                    OVER(

                        PARTITION BY

                            A,

                            B,

                            C

                        ORDER BY

                            A ASC,

                            B ASC,

                            C ASC

                    ) = 1

                THEN

                    "Duration"

            ELSE NULL

        END

Hi team..This is the oracle code.. Can anyone let me know, how can we use the same in qlikview UI part not in script side..

[sunny_talwar · Accepted solution]

I would add A, B, C as dimensions, sort them in ascending order (first by A, then B, then C) and then may be this as your expression

If(RowNo() = 1, 'Duration')

[vipingarg23]

Excellent Sunny, as usual.. Thanks for your help..