Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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.
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?
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.
Nice Thanks for clarifying mate!
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
Hi Harsha,
Check attached file for solution. Check the left chart, with Calculated Dimension. Hope this is what you requires.
Regards,
Jagan.
Awesome!
Wish i had the option of marking both the answers as correct
Thanks a ton Jagan!
-Harsha