Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
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
Still be Waiting
LOAD Date(Date,'DD/MM/YYYY') as Date,
MonthName(Date) as MonthYear,
(ooxml, embedded labels, table is Data);
Max(Date) as Date, 1 as Flag
Group By MonthYear;
DROP Table Data;
i want to create in Only in straight table Using 15 expression.