topic Urgent: Straight Table Query in QlikView

Urgent: Straight Table Query

Fri, 06 Apr 2012 05:27:15 GMT

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

Urgent: Straight Table Query

jagan — Fri, 06 Apr 2012 05:47:06 GMT

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.

Re: Urgent: Straight Table Query

jagan — Fri, 06 Apr 2012 06:05:22 GMT

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.

Urgent: Straight Table Query

Jason_Michaelides — Fri, 06 Apr 2012 07:00:36 GMT

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?

Urgent: Straight Table Query

jagan — Fri, 06 Apr 2012 07:07:02 GMT

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.

Urgent: Straight Table Query

Jason_Michaelides — Fri, 06 Apr 2012 07:33:53 GMT

Nice Thanks for clarifying mate!

Urgent: Straight Table Query

Fri, 06 Apr 2012 14:16:29 GMT

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

Re: Urgent: Straight Table Query

jagan — Fri, 06 Apr 2012 15:02:32 GMT

Hi Harsha,

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

Regards,

Jagan.

Urgent: Straight Table Query

Fri, 06 Apr 2012 15:09:57 GMT

Awesome!

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

Thanks a ton Jagan!

-Harsha