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.
