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?