Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikeers
Creator
Creator

Pivot table - stock and sales in one table

Hi!

I have a question - I have a concatenated table with stock levels and sales values. I would like to design a pivot table that will present everything in numbers and values as in the attachment. Do you have an idea? I can handle the division of clients (specified client). "sales other" is the difference between "all / total" and "scpecified client".

1 Reply
JordyWegman
Partner - Master
Partner - Master

Hi,

This is possible. Just get Products as the first dimension, Weeks as the second and then add all your measures. When concatenated correctly on the fields Products and Weeks this will work.

The concatenation of the two fields is important otherwise it will not work. Check if they have the same name/definition.

Jordy

Climber

Work smarter, not harder