Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaysingh
Specialist II
Specialist II

Expression Help

I have Table in which

Customer code          customer Name          Pre-Tax Value for CY          Pre-Tax Value for LY

01                                        X                              100                                        110    

02                                        Y                               150                                        140

03                                        Z                               50                                           60

04                                        A                               10                                           08

05                                        D                               200                                        190

On the basis of Pre-Tax Value I Want RANK calculation for CY and LY.

e.g. For CY    Pre-Tax value CY              RANK

                         200                                   1

                         150                                   2

                         100                                   3

                           50                                   4

                          10                                    5

6 Replies
jyothish8807
Master II
Master II

Hi Abhay,

Create a  two expression new field .

=Rank(Pre-tax Value CY)

=Rank(Pre-tax Value LY)

Regards

KC

Best Regards,
KC
abhaysingh
Specialist II
Specialist II
Author


hi Jyothish

Not working, already tried

jyothish8807
Master II
Master II

As per your data it should work.Can you share your app?

Regards

KC

Best Regards,
KC
anbu1984
Master III
Master III

Rank(TOTAL [Pre-Tax Value for CY])

abhaysingh
Specialist II
Specialist II
Author

sorry not working

maleksafa
Specialist
Specialist

can you upload a sample document maybe we can help you better.