topic Select a specific value in a dimension - display data from the last date with data. in QlikView

Select a specific value in a dimension - display data from the last date with data.

Thu, 06 Jan 2011 21:48:47 GMT

Hi Everyone,

I have telephone statistics that I would like to display in a pivot table using 2 dimensions and 10 expressions. See below:

Dimension 1 is [Call Date] and 2 is [Agent #]. The expressions are various counts of incoming/outgoing calls and average times.

The goal is to only display the last [Call Date] not equal to today. The last [Call Date] is "01-05-11", how do I identify this date (either in the Load or set analysis?) and only display the expressions from this date?

Thank you for your time!

Sarah

Select a specific value in a dimension - display data from the last date with data.

pover — Thu, 06 Jan 2011 22:28:03 GMT

In script create a flag in the following manner:

if([Call Date]=today(), 0,1) as Call_Date_Flag

Then in your expression put

avg(Time * Call_Date_Flag)

Or else with set analysis try

avg({$<[Call Date]={"=[Call Date]<>today()"}>} Time)

Regards.

Select a specific value in a dimension - display data from the last date with data.

Thu, 06 Jan 2011 22:50:28 GMT

Thank you for the information!

Just to clarify - there is no way to filter a dimension? I would like to avoid modifying the existing expressions. 🙂

Thanks!

Sarah

Select a specific value in a dimension - display data from the last date with data.

pover — Thu, 06 Jan 2011 23:02:02 GMT

Sure. Just use the expression the above set analysis to filter the call dates

=[Call Date]<>today()

and create a bookmark with that filter and then you can apply it automatically using an action each time you open the document.

Regards.