Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

table with two expression in a cell

hi all.

is it possibile create a table like this:

ScreenHunter_001.jpg

 

 

 

 

My dimension is the Year, % are on total.

thanks in advance

Andrea

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

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...

View solution in original post

8 Replies
Highlighted
Creator
Creator

Y cant you load it from text or excel
Highlighted
Contributor II
Contributor II

Hi.

Numbers must be changed according on the selection

Highlighted
Creator III
Creator III

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.

Highlighted
Contributor II
Contributor II

Thanks, but is not good for me.

Andrea

Highlighted

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

Highlighted
Creator
Creator

Creat it from Excel

Highlighted
Creator III
Creator III

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...

View solution in original post

Highlighted
Contributor II
Contributor II

Great! thank you very much