Urgent: Straight Table Query

[#1]

Hi all,

I need help. I have a straight table with one dimension and three variables. I want to create four tables out of this master table.

Table1: I want to show the top 1-50 branches in this table
Table2: I want to show the top 51-100 branches in this table

Table3: I want to show the bottom 1-50 branches in this table
Table4: I want to show the bottom 51-100 branches in this table

Find attached the qlikview file with my data. I am new to qlikview, it would be great if you can share an example of how i can do this.

Thank you!

- Harsha

[jagan]

Hi,

Which version of Qlikview you are using?  If you are using QV 11 then there is a functionality in Dimension Limits table of Chart Properties.  You can set Top 50, Bottom 50 or anything you wish.

Hope this helps you.

Regards,

Jagan.

[jagan · Accepted solution]

Hi,

I please check the attached file for solution.  I completed

Table1: I want to show the top 1-50 branches in this table
Table2: I want to show the top 51-100 branches in this table

Table3: I want to show the bottom 1-50 branches in this table

Give a try for Table 4.

Regards,

Jagan.

[Jason_Michaelides]

I can't see how you've done this Jagan!  There aren't any dimension limits set and the expressions are all the same!  How did you achieve this?

[jagan]

Hi Jason,

Since I don't have QV 11 installed in my machine, I did this in QV 9.   I used Presentation tab Max Number(1-100) and I given 50 here and sorted the chart by V1/V2 descending, this shows top 50.

Using V1/V2 ascending order Presentation tab Max Number(1-100) and I given 50, this shows bottom 50.

I used Rank() for 51-100 and used Presentation tab Max Number(1-100).  You can check the expression.

Hope I explained better.

Regards,

Jagan.

[Jason_Michaelides]

Nice   Thanks for clarifying mate!

[#7]

Worked Perfectly. Thanks a lot Jagan!

One quick question. I was just wondering if there is a way in which i can restrict the number of rows to only those records which satisfy the condition (sum(V2) >= 100). Once i am able to filter them, i would like to create the four tables. It would be great if u can share your thoughts.

Thanks!

- Harsha

[jagan]

Hi Harsha,

Check attached file for solution.  Check the left chart, with Calculated Dimension.  Hope this is what you requires.

Regards,

Jagan.

[#9]

Awesome!

Wish i had the option of marking both the answers as correct

Thanks a ton Jagan!

-Harsha