Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

panipat1990
Contributor II

MONTHLY TREND CALCULATION

Dear Team,

I stuck a requirement.I have a data from Last Two years. And i want to make monthly trend report in straight table One to one expression. For this i make a result format below.

IDCMCM-1CM-2CM-3CM-4CM-5CM-6CM-7CM-8CM-9CM-10CM-11CM-12CM-13CM-14

Each Month's Column Data Should be On Max Date..Suppose in one Month 4 Dates exists Like In Feb Month 22 Feb,23 Feb,24 Feb.

In CM-1's Column data only 24 feb means each month's maximum date..same like previous month..


For this i am sharing data ..In Each Column  data exists only maximum date. And Second Sheet Result As required

3 Replies
panipat1990
Contributor II

Re: MONTHLY TREND CALCULATION

Still be Waiting

mdmukramali
Valued Contributor II

Re: MONTHLY TREND CALCULATION

Hi Gourav,

Data:

LOAD Date(Date,'DD/MM/YYYY') as Date,

MonthName(Date) as MonthYear,

     Sale,

     ID

FROM

(ooxml, embedded labels, table is Data);

Join(Data)

LOAD MonthYear,

  Max(Date) as Date,  1 as Flag

Resident Data

Group By MonthYear;

NoConcatenate

LOAD *

Resident Data

Where Flag=1;

DROP Table Data;

panipat1990
Contributor II

Re: MONTHLY TREND CALCULATION

i want to create in Only in straight table Using 15 expression.

Community Browser