topic Re: Re: Table of this format in QlikView

Table of this format

Wed, 02 Apr 2014 04:24:35 GMT

Hi All,

I want the table of this format.

I have data for DTD(Trading), MTD(Trading), YTD(Trading), DTD(Sales), MTD(Sales) and YTD(Sales).

Thanks & Regards,

Keerthi

Re: Table of this format

sujeetsingh — Wed, 02 Apr 2014 04:29:06 GMT

Possible by using pivot table with pivot option expanded

Re: Re: Table of this format

Wed, 02 Apr 2014 04:37:03 GMT

How do i do in a pivot table ???

Please check my Qvw

Re: Re: Re: Table of this format

Anonymous — Wed, 02 Apr 2014 05:17:12 GMT

PFA

Re: Table of this format

nizamsha — Wed, 02 Apr 2014 05:22:42 GMT

I used to follow this kind of trick PFA if u like

Re: Table of this format

Anonymous — Wed, 02 Apr 2014 05:51:09 GMT

Gr8, you mark your ques only to be correct answer............

Re: Re: Table of this format

Wed, 02 Apr 2014 05:54:56 GMT

Ha ha

It was by mistake

Re: Re: Re: Re: Table of this format

Wed, 02 Apr 2014 06:54:46 GMT

Hi Nitin,

You have used one single expression for the table.

What if i have multiple expressions such as MTD, DTD and YTD.

Attached is the Qvw.

Thanks & Regards,

Keerthi

Re: Re: Re: Re: Table of this format

Anonymous — Wed, 02 Apr 2014 07:09:29 GMT

Then we have to use if as below:

if(CATEGORY='Trading',

if(Type='DTD',sum(TradePrice),

if(Type='MTD',sum(TradePrice),

if(Type='YTD',sum(TradePrice)))),

if(Type='DTD',sum(SalePrice),

if(Type='MTD',sum(SalePrice),

if(Type='YTD',sum(SalePrice))))

)

Re: Table of this format

Wed, 02 Apr 2014 07:23:16 GMT

Thanks a lot nitin

Also i want to know how to forecast data for next one month .

Do you have any examples of forecasting ?

Thanks & Regrads,

Keerthi

Re: Table of this format

Anonymous — Wed, 02 Apr 2014 08:43:06 GMT

Forecasting can be done on basis of particular formula .

First of all you to drive a formula for the same that can be used in chart.

I think , WHAT IF analysis would help you out for forecasting.

You can check with the examples/demos for the same.