Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

arvind_patil
Valued Contributor III

Pivot Table in Qliksense

Hi Experts,

How can I achieve below table in qliksense.

pivot.png

In That :

Product Is my Dimension

MonthYear is my Column

Exp1 and Exp2 is my measures .

Please  guide me.

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
arvind_patil
Valued Contributor III

Re: Pivot Table in Qliksense

Please help ,

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

arvind_patil
Valued Contributor III

Re: Pivot Table in Qliksense

Thanks for reply ,

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

adwitiya
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

Sorry My Bad.. It seems i uploaded a wrong one.

I have changed it. Please check new one.

Regards,

Kaushik Solanki

arvind_patil
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

arvind_patil
Valued Contributor III

Re: Pivot Table in Qliksense

Hi Adwitya,

No its not that way. I have already Year month wise data I want it on pivot table

regards,

Arvind Patil

Community Browser