Discussion board where members can learn more about Qlik Sense App Development and Usage.
Below is the Original data we need an expression to be created which will exclude min and max date transaction and give us all the transaction for a particular script id.
Main:Load ScriptId,date#(Date,'MM/DD/YYYY') as Date,Amount inline [ScriptId,Date,AmountItem A,01/01/2022,100Item A,01/01/2022,50Item A,01/02/2022,75Item A,01/03/2022,150Item A,01/04/2022,100Item A,01/05/2022,50Item A,01/06/2022,25Item A,01/07/2022,50Item A,01/07/2022,75Item B,01/02/2022,40Item B,01/03/2022,10Item B,01/03/2022,30Item B,01/03/2022,60Item B,01/04/2022,30Item B,01/05/2022,20Item B,01/06/2022,10Item B,01/08/2022,20Item B,01/08/2022,30];
inner Join(Main)Load ScriptId as ScriptId,Date(mindt+Iterno()) as DateWhile mindt+Iterno() < maxdt;Load ScriptId,min(Date) as mindt,max(Date) as maxdtResident MainGroup by ScriptId;
Thanks for your reply,
We need this in formula expression, not load script.
Either use a calculated dimension for Date field
=Aggr(if(Date>min(total <ScriptId> Date) and Date<max(total <ScriptId> Date),Date),ScriptId,Date) <<for Date calculated dimension
OR restrict in measure as below
=sum(aggr(if(Date>min(total <ScriptId> Date) and Date<max(total <ScriptId> Date),Amount),ScriptId,Date))
@TauseefKhan kindly close the thread if your query is resolved