0 Replies Latest reply: Mar 16, 2018 11:45 AM by Ale Kong RSS

    Editing expression to get current QTD and last QTD

    Ale Kong

      Hi,

       

      New to Qlik and don't want to mess too many things up in an existing app. I have an expression that is currently getting current YTD data. There is a column in the data set called Quarter_new with data populating Q1, Q2, Q3, or Q4. There is also a column Year_new with the correct year. Is there a way to just edit the expression syntax to get QTD data and last QTD?

       

      Current Expression:

      if([_dimension2]='Cycle Time -Average cycle time – Print',

      round(avg({<Date_new={'>=$(vYTDCYStart)<$(vYTDCYEnd)'},Year_new=,Month_new=,Quarter_new=,Medium={'Print/Physical'},Product=,Franchise=>}[FF - Time to AFU (Days)])),

      if([_dimension2]='Cycle Time -Average cycle time – Digital'

       

      Appreciate anyone's help on this.

       

      Thanks,

      Ale