# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Valued Contributor III

## Pivot Table in Qliksense

Hi Experts,

How can I achieve below table in qliksense.

In That :

Product Is my Dimension

MonthYear is my Column

Exp1 and Exp2 is my measures .

Regards,

Arvind Patil

1 Solution

Accepted Solutions

## Re: Pivot Table in Qliksense

Hi,

Find the expected output in attached QVF.

Regards,

Kaushik Solanki

14 Replies
Valued Contributor III

## Re: Pivot Table in Qliksense

Any Extension or is this possible in pivot or not.

Regards,

Arvind Patil

## Re: Pivot Table in Qliksense

Hi,

Find the expected output in attached QVF.

Regards,

Kaushik Solanki

Valued Contributor III

## Re: Pivot Table in Qliksense

but what you gave me that is not what i actually looking  for.

Regards,

Arvind Patil

## Re: Pivot Table in Qliksense

Then what are you looking for?

The output is similar to what you have shown in image.

Regards,

Kaushik Solanki

Contributor

## Re: Pivot Table in Qliksense

One way to do this would be to load a new field when you load your data.

if(Year([Date])= year(Today()),

if( num(Month([Date]))<num(Month(Today())),(Exp1)))

As Exp1_ToDate_CY,

if(Year([Date])= year(Today())-1,

if( num(Month([Date]))<num(Month(Today())),(Exp1)))

As Exp1_ToDate_PY,

In your chart calculation, calculate Exp1_ToDate_CY - Exp1_ToDate_PY.

This code is not tested and you may get a syntax error. But you'll get the logic here.

Let me know if this works out for you.

## Re: Pivot Table in Qliksense

I have changed it. Please check new one.

Regards,

Kaushik Solanki

Valued Contributor III

## Re: Pivot Table in Qliksense

Thanks for prompt response.

no its completely different you gave me one scatter chart and one text object .

I require pivot table in above mentioned format.

Regards,

Arvind Patil

## Re: Pivot Table in Qliksense

In my previous post. Replaced the old one with new one.

You can see a name difference i.e New file name is Comm285777.qvf

Regards,

Kaushik Solanki

Valued Contributor III