Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Show & Hide column in same table with fixed showing location

Hi,

Could anyone give me a hint how to display column as this demo below? Basically, we have 4 columns, but we only want to show 1 and hide the rest 3 when selected and the display column location won't shift as this demo link below. Thanks !

QlikView

Tags (4)
1 Solution

Accepted Solutions
Not applicable

Re: Re: Show & Hide column in same table with fixed showing location

Attached are the excel files with the exported data.

The Currency table was created in the loadscript consisting of only two fields loaded from other tables

8 Replies
Not applicable

Re: Show & Hide column in same table with fixed showing location

What part of that demo are you looking to duplicate?

Not applicable

Re: Re: Show & Hide column in same table with fixed showing location

Look at the actual qvw I attached and you can just copy whatever expressions and/or settings they used to make your desired actions

Not applicable

Re: Re: Show & Hide column in same table with fixed showing location

Thanks a ton Robert ! This is an immense help, really appreciate

Not applicable

Re: Re: Show & Hide column in same table with fixed showing location

Hi Robert, if possible, could you please help me with some samples of these QVD files embedded? So, I don't need to type line by line again. Fyi, I am build a demo to show the management team to encourage more people to use Qlikview in my company.

Database\Qvd\Currency.qvd

Database\Qvd\AUM.qvd

Database\Qvd\Performance.qvd

Database\Qvd\Positions.qvd

Database\Qvd\Trades.qvd

Database\Qvd\Risk.qvd

Database\Qvd\Composition.qvd

Database\Qvd\Holdings.qvd

Not applicable

Re: Show & Hide column in same table with fixed showing location

That's actually a qlikview demo.  If you want the source data you could always just make some table boxes and export them to excel

Not applicable

Re: Re: Show & Hide column in same table with fixed showing location

Attached are the excel files with the exported data.

The Currency table was created in the loadscript consisting of only two fields loaded from other tables

Not applicable

Re: Show & Hide column in same table with fixed showing location

I am super impressed with your quick responses and very practical help. I was able to construct small sets of data and create some models based on your sample template. The template helps me to understand lots of helpful Data Set applications. Thanks a ton again Robert !

Not applicable

Re: Show & Hide column in same table with fixed showing location

No problem!  Good luck!