topic Re: Cross Table Concpet in QlikView

Cross Table Concpet

abhaysingh — Thu, 13 Aug 2015 07:03:40 GMT

Hi Guys,

I am Performing Cross Table and my Data is getting Multiplied and I know this will happen..

I want to know how I can handle this?

I have Target data in row form, I changed it to Column with the help of cross table. Now Month Frequency is 386 for all 12 month,

Available targets are State and Month wise Target and I have to link with the help of State to One master Table, but how I can link it with Calender?

Regards

Abhay

Re: Cross Table Concpet

MK_QSL — Thu, 13 Aug 2015 07:19:00 GMT

Provide sample data or sample application please

Re: Cross Table Concpet

abhaysingh — Thu, 13 Aug 2015 07:55:58 GMT

Pls find the sample data...

need to know how I can manage these records which are multiplying?

Re: Cross Table Concpet

MK_QSL — Thu, 13 Aug 2015 08:09:40 GMT

CrossTable(Month, Value,4)

LOAD State,

[Name of Person],

ReportingManager,

Head,

Jan,

Feb,

Mar,

Apr,

May,

Jun,

Jul,

Aug,

Sep,

Oct,

Nov,

Dec

FROM TABLE;

Re: Cross Table Concpet

sunny_talwar — Thu, 13 Aug 2015 08:27:48 GMT

Use this script if you only want data where it's not equal to 0:

Table:

CrossTable(Month, Data, 4)

LOAD State,

[Name of Person],

ReportingManager,

Head,

Jan,

Feb,

Mar,

Apr,

May,

Jun,

Jul,

Aug,

Sep,

Oct,

Nov,

Dec,

Total

FROM

(ooxml, embedded labels, table is Sheet1);

Table1:

NoConcatenate

LOAD *

Resident Table

Where Data <> 0;

DROP Table Table;

Output:

Re: Cross Table Concpet

abhaysingh — Thu, 13 Aug 2015 10:42:59 GMT

Hey guyz thanks for the revert...but this is something m already doing.. I want to know Records are Repeating when I will join it to meet my requirement than Total Number of records will Multiply and will give me wrong result..

need solution like record should not multiply that's why want to know how I can do it.

thanks