topic table with two expression in a cell in QlikView

table with two expression in a cell

andrea1 — Sat, 16 Nov 2024 02:39:09 GMT

hi all.

is it possibile create a table like this:

My dimension is the Year, % are on total.

thanks in advance

Andrea

Re: table with two expression in a cell

sugathirajkumar — Fri, 23 Aug 2019 10:56:34 GMT

Y cant you load it from text or excel

Re: table with two expression in a cell

andrea1 — Fri, 23 Aug 2019 11:00:55 GMT

Hi.

Numbers must be changed according on the selection

Re: table with two expression in a cell

jensmunnichs — Fri, 23 Aug 2019 11:28:12 GMT

Hi,

I think you're best off using a pivot table to achieve this.

This is the closest I could get to your image (see attachment). I added 'Sales level 2' to make up the rest of the total amount of sales per year. If I've misunderstood what your source data looks like, please post some sample data to work with.

Re: table with two expression in a cell

andrea1 — Fri, 23 Aug 2019 11:33:41 GMT

Thanks, but is not good for me.

Andrea

Re: table with two expression in a cell

sunny_talwar — Fri, 23 Aug 2019 11:49:53 GMT

What is not good about this? Do you want to provide some more info?

Re: table with two expression in a cell

sugathirajkumar — Fri, 23 Aug 2019 11:52:36 GMT

Creat it from Excel

Re: table with two expression in a cell

jensmunnichs — Fri, 23 Aug 2019 11:56:47 GMT

I managed to get even closer to the table in your image, though imo this one is a bit messier.

If this still isn't what you need I'm not sure I can help, especially if you don't give me any feedback on what's not good about it...

Re: table with two expression in a cell

andrea1 — Fri, 23 Aug 2019 12:45:01 GMT

Great! thank you very much