Compare data with one table

Thu, 28 Jan 2016 17:00:37 GMT

Dear all,

I'm quite new on Qulik View and a little bit confused on how proceed for the following case:

I have the following field in a TABLE:

MTM_DATE,

MTM_CM_NAME,

MTM_PERIOD,

MTM_MTM,

Portfolio,

Company,

Counterparty,

Vessel,

Exposure Type],

Contract_status,

Nature,

[vessel type],

left(MTM_PERIOD,4) as "Year",

mid(MTM_PERIOD,5,2) as "Month",

if (mid(MTM_PERIOD,5,2) <=3, 'Q1', if(mid(MTM_PERIOD,5,2) <=6, 'Q2', if (mid(MTM_PERIOD,5,2) <=9, 'Q3', 'Q4'))) as "Quarter"

In need to compare the SUM of the filed MTM_MTM in the following way:

I can make a first set filtering by all this fields that will be unique for both MTM_MTM SUM:

Portfolio,

Company,

Counterparty,

Vessel,

Exposure Type],

Contract_status,

Nature,

[vessel type],

Then I need to make comparation between two different selections between the fields:

Year

MTM_DATE

Month or Quarter

I'm confused on how to use(create) variable for this 4 fields and what about the syntax of the expression for the second sum to compare and related to variables selection should be because it must be conditioned from YEAR, MTM_DATE and Month or Quarter.

May someone help me for this?

Thank you

topic Compare data with one table in QlikView

Compare data with one table