Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody, I am using qlik cloud and I want to achieve an expression that calculates the number of teus per day but disregards any current date selections. I am currently using the following expression that considers the date selections: Avg( Aggr(TEU, TRACER_USER_ID, (DATE)) ). So, if I have for example a period of 2 months selected I want my expression to be able to calculate the average number of TEU's per day but for the complete period and not only for those 2 months.
You can list use set analysis to ignore selection in certain fields like this:
avg({<FieldToIgnore= , AnotherFieldToIgnore= >} FieldName)
Does that help?