topic Re: Load theme from excel in QlikView

Load theme from excel

Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

I have an excel file for theme.

Colors Excel:

I want to load this file in qvw file. For each pivots and straight table i want to apply some theme from this excel.

So how can i achieve the same ?

Thanks.

Re: Load theme from excel

adamdavi3s — Thu, 18 Aug 2016 08:46:29 GMT

That looks similar to the file explained here:

Color Logic – loading multiple Color schemes

please remeber to mark this answer as helpful or correct if it was

Re: Load theme from excel

Thu, 18 Aug 2016 09:34:29 GMT

Thanks for your reply.

I have a trial version of qlikview, So i am unable to open that qlikview file.

Can you help me how i can i achieve it ?

Re: Load theme from excel

adamdavi3s — Thu, 18 Aug 2016 09:39:04 GMT

To be honest you don't really need the file, just follow the instructions on that document.

To make it simpler to follow I would switch your columns and rows in your excel spreadsheet so themes are across the top and the colour types are down the side.

Then you will pretty much just be able to follow the thread like for like to get it working.