23 Replies Latest reply: Nov 15, 2017 9:52 PM by Anil Babu

Relative positioning of straight tables

Hi,

In a sheet I have 4 straight tables and 7 text boxes (used as headers) which are displayed as one single chart as shown below

Usually there will be 9 rows in the first straight table but when there are less than 9 rows there is a big gap between the 1st table and the below 3 tables.

I wanted to see if there is a way the bottom charts gets tagged along with the first chart based on the data.

I would really appreciate your help ASAP.

Thanks!

• Re: Relative positioning of straight tables

Unfortunately, it can be done using Qlikview

• Re: Relative positioning of straight tables

Thanks for your prompt response Anjos.

Is it possible to create an inline table with all the 9 LOB values and display it in first row and respective values in the expressions?

• Re: Relative positioning of straight tables

May be share sample data, I believe it can be achievable using Island Table With Pick(Match(...)...) on top.

• Re: Relative positioning of straight tables

Sure Anil.

Please see the sample.qvw attached to the original post.

• Re: Relative positioning of straight tables

May be missed attachment

• Re: Relative positioning of straight tables

Note - This data is from JPMC. Make sure to delete after issue got resolved

• Re: Relative positioning of straight tables

Sure, I will.

reloaded and attached the sample to the original post.

• Re: Relative positioning of straight tables

PFA

You can add, Remain and check. In fact, Your tables are not filterable due to constant and my table looks like filter also happened.

HTH

Anil

• Re: Relative positioning of straight tables

Thanks much Anil.

But here the totals should be in the middle of the table after LOB or even at the end it should display only LOB rows totals.

Is it possible?

• Re: Relative positioning of straight tables

Yes, Possible. You can add one more Label for that in dimension then use same formula for that as pattern in seq. order. You can achievable. I may help you in documentary after 6 PM due to client space ..

• Re: Relative positioning of straight tables

I would really appreciate if you could help me with this Anil. I tried but no luck

Please check the dimension column in below screenshot...

order - USER_LOB, All Legal (sum of all LOB rows), Non Legal, Bulk Upload, USER_Region

• Re: Relative positioning of straight tables

Also from what you've suggested, I see same values is repeating in last 2 rows - UPLOAD,AMER

• Re: Relative positioning of straight tables

Yes, Because, I've edited only Employee Count. That's what I've initiate to you. you can edit and use formulas where i have done. Just copy paste for that and looks it is achievable. I am sure 100% you will deserve it in this duration. In fact, in my client machine there is no software installed yet. So, I would offer you after 6 PM for sure.. Keep post update what you did after 4 PM. So then i can look the same in my personal PC.

• Re: Relative positioning of straight tables

I got change to work your file, PFA

Note - Please use formula of yours for "All Legal". I am currently working as static and make sure it should be in dynamic. And full busy schedule today.  may work for you if i have free time

• Re: Relative positioning of straight tables

Thanks Anil.

I'll try based on this, will contact you if I need any further help on this.

• Re: Relative positioning of straight tables

Hi Anil,

I'm not able to get the ALL LEGAL total values - sum of all the LOB values and also I don't see UPLOAD in the dimensions at all.

I would really appreciate if you could help me with this.

Thanks!

• Re: Relative positioning of straight tables

I created a view and utilized it in Qlikview to achieve this.

• Re: Relative positioning of straight tables

Hi Anil,

PFA sample(2).qvw with the changes based on your suggestions.

Bulk-Upload and Non-Legal value should always be displayed in the dimensions but I don't see those.

Also All Legal should display the sum on USER_LOB values and it should match the sum of USER_REGION values.

Also how did you highlight the 'All Legal' row in your sample? I tried custom format cell but it is changing the entire dimension font and background.

Can you please take a look a help me out on this asap? I've to complete this today

Thanks!

• Re: Relative positioning of straight tables

Also how did you highlight the 'All Legal' row in your sample? I tried custom format cell but it is changing the entire dimension font and background.

I've applied BG color

=If(Pick(Dim, LOB, if(USER_REGION = 'AMER' or USER_REGION = 'EMEA' or USER_REGION = 'APAC', USER_REGION, 'OTHER'), 'All Legal', 'NON LOB', 'UPLOAD')='All Legal', RGB(245,245,245))

And, Text format like below

=If(Pick(Dim, LOB, if(USER_REGION = 'AMER' or USER_REGION = 'EMEA' or USER_REGION = 'APAC', USER_REGION, 'OTHER'), 'All Legal', 'NON LOB', 'UPLOAD')='All Legal', '<B>')

All Legal should display the sum on USER_LOB values and it should match the sum of USER_REGION values.

Can you explain practically how values are fetching, Because If i change formula like

Count({<USER = {"=USER = USER_REGION"}>} USER)

OR

Count(If(USER = USER_REGION,USER))

Values are coming, But not matching ass expected. Please explain little more ..

And For sorting, I used LOB by Expression like

=Match(Pick(Dim, LOB, 'All Legal', 'NON LOB', 'UPLOAD', if(USER_REGION = 'AMER' or USER_REGION = 'EMEA' or USER_REGION = 'APAC', USER_REGION, 'OTHER')),

LOB, 'All Legal', 'NON LOB', 'UPLOAD',if(USER_REGION = 'AMER' or USER_REGION = 'EMEA' or USER_REGION = 'APAC', USER_REGION, 'OTHER'))

And Text from A-Z Ascending ..

• Re: Relative positioning of straight tables

Hello Experts,