topic Re: Beside having 2 table in one sheet , it is possible to make it only 1 table in one sheet ? in QlikView

Beside having 2 table in one sheet , it is possible to make it only 1 table in one sheet ?

paulyeo11 — Tue, 14 Feb 2017 14:28:12 GMT

Hi All

I have Table 1 and 2 in one page.Now it occupy 2 sheet.I want to reduce to one sheet

The different betweeen the 2 table is one display the sales another one display the Qty.

One alternative i create 2 sheet in one sheet. that is one is min and one max. Another alternative i can think of using the button the change the Qty or Sales.

What are the next Alternative ?

Hope some one can share with me.

Paul

Re: Beside having 2 table in one sheet , it is possible to make it only 1 table in one sheet ?

paulyeo11 — Tue, 14 Feb 2017 14:29:31 GMT

my QVW

Re: Beside having 2 table in one sheet , it is possible to make it only 1 table in one sheet ?

Anonymous — Tue, 14 Feb 2017 14:46:44 GMT

You can Group the Expressions in the Expressions Tab and click the arrow icon to switch

Example Attached

Re: Beside having 2 table in one sheet , it is possible to make it only 1 table in one sheet ?

vishsaggi — Tue, 14 Feb 2017 15:00:09 GMT

Why don't you merge the two expressions like Qty and Sales. ? I quite did not get you what is your expected output? Can the below suffice your requirement?

Re: Beside having 2 table in one sheet , it is possible to make it only 1 table in one sheet ?

paulyeo11 — Wed, 15 Feb 2017 03:17:43 GMT

Hi Gareth

Thank you your suggestion is good. this is the first time i get to know this approach.

Paul

Re: Beside having 2 table in one sheet , it is possible to make it only 1 table in one sheet ?

paulyeo11 — Wed, 15 Feb 2017 03:19:03 GMT

Hi Vish

Thank you for your reply.

I try not to give some much information , But then carefully look at the table you create , is quite neat. so i may try too.

Paul Yeo

Re: Beside having 2 table in one sheet , it is possible to make it only 1 table in one sheet ?

eromiyasimon — Wed, 15 Feb 2017 04:54:24 GMT

you can do that by conditional using variable

im not sure that you are expecting like this

but i hope this may help you

Re: Beside having 2 table in one sheet , it is possible to make it only 1 table in one sheet ?

paulyeo11 — Wed, 15 Feb 2017 05:01:02 GMT

Hi Ero

Thank you for your sharing.

Your approach is good , but suddenly my sheet come out 2 button, May i know how to make it become like :-

Re: Beside having 2 table in one sheet , it is possible to make it only 1 table in one sheet ?

eromiyasimon — Wed, 15 Feb 2017 05:19:29 GMT

fixed

Re: Beside having 2 table in one sheet , it is possible to make it only 1 table in one sheet ?

paulyeo11 — Wed, 15 Feb 2017 11:15:50 GMT

Hi Ero

May i know how to modify the below code , so that it will change the color from org to green ? and dark Gary to light gray ?

if(Vshowtable=2,RGB(255,128,64),RGB(127,127,127))

Re: Beside having 2 table in one sheet , it is possible to make it only 1 table in one sheet ?

eromiyasimon — Wed, 15 Feb 2017 11:40:52 GMT

go to object properties -> go to color -> go to calculated

change the RGB values

attached the updated file

Re: Beside having 2 table in one sheet , it is possible to make it only 1 table in one sheet ?

paulyeo11 — Wed, 15 Feb 2017 11:51:16 GMT

Hi Ero

Thank you , I further Google RGB values and I change 172 to 224 . Now look perfect.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +659:261804