Help with Pivot Table

[Nemo1]

Hello everyone

So my problem is the following. 

I have a dataset, where I have a column called "Month" and another column called Sales. 

I need to display the different months in QlikSense as columns. To explain myself better, I need for every month, a column. How can I do that?

thanks 

[Kushal_Chawda]

@Nemo1  Not sure what do you mean. Probably you can share screenshot of required format. 

[Nemo1]

So I have the data in excel represented like this:

and i wanna have it in qlik sense showed like this:

thanks!

[Or]

This looks like a standard pivot table, with the Measures dragged to the left (row) side and the date in the pivot (column) side. Are you having some sort of specific issue with this?

[sergio0592]

Hi,

You can try with the Generic load as 

GENERIC LOAD Date, Sales, Cost
RESIDENT YourTable;

[Kushal_Chawda · Accepted solution]

@Nemo1  Create pivot table with Column dimension Month. Create two measure for Sales & Cost. Drag the values of Measure to Row Dimension

[Nemo1]

It does not work, because when I do that, I get one column for the dates, and then each date represent one row. I need to have for each month, a different column.. 😞

[Nemo1]

It does not work, because when I do that, I get one column for the dates, and then each date represent one row. I need to have for each month, a different column..

[Fabiano_Martino_Intelco]

Hi @Nemo1 ,

can you post a screenshot of what you get and a screenshot of ther configuration of your pivot table, so we can better understand how it is configured?

Regards

Fabiano

[Nemo1]

Hello 

Sure, thanks for answering.

This is my input table:

This is what I am aiming to have

I am stuck . Any help is appreciated!