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
    Ale Kong Mar 16, 2018 11:45 AM

      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