0 Replies Latest reply: Mar 28, 2017 5:56 AM by Patrizia Gesualdi RSS

    Dinamic Filter Date

    Patrizia Gesualdi

      Hello,

       

      i would like to create in QlikSense 3.0 a time dimension that consider a different type of time based on variable value.

       

      Eg. In my data source I have fields "Year Invoice" and 'Year Sale" and i want that user can choose  to filter data of app by Year Invoce or by Year Sale, having only one filter "Year".

      So I create a variable vFilter and a dimension "Year" = If(vFilter = 1, Year Invoice, Year Sale).

      User can give value to variable by an extension.

       

      Maybe it is'nt the correct way because it is'nt work.

       

      Any idea to do this please?

       

      Thanks

      Patrizia