Discussion Board for collaboration on QlikView Scripting.
I have data something like below -
Now there are two entries for the conversation IDs 12 and 14. But for ID -12 in the same month there are two entries. For ID - 14 there are two entries in the different month.
If it is same month I want to show only latest record. For EX: ID - 12 I should show 9/9/2017 record row.
If it is different month I want to show both the records. For EX: ID - 14 I should show 9/17/2017 and 10/15/2017 record rows.
This is the script that I am trying to achieve this -
year(ClosedDate) as Year,
Month(ClosedDate) as Month,
(ooxml, embedded labels, table is Sheet1);
Load ConversationID, Max(ClosedDate)as ClosedDate Resident Input group By ConversationID;
But this is not giving me two records it IDs belongs to two different months. This needs to be done in scripting.
Final Output should be like this -
Can anyone help me to achieve this?
Go to Solution.
Put Month inside the Load and use it in the gruop by if you want to have max on every month.
Load ConversationID, Max(ClosedDate)as ClosedDate, Month Resident Input group By ConversationID, Month;
Thanks for your reply..
It wont work in my scenario.
As per the example that I have provided above ,
Thank You.. Its working now..