topic Re: Pie Chart Dimension filter in QlikView

Pie Chart Dimension filter

Anonymous — Thu, 07 Nov 2013 12:13:13 GMT

I have a pie chart that shows the staff count for staff starting with the organisation. This has a dimension is by 'Division'.

I only want to show the data within the chart for any staff starting after Jan 2013 and earlier than today (planned start date).

As I do not have the date dimension in my pie chart, how do I do this?

Thanks

Phil

Nicole-Smith — Thu, 07 Nov 2013 13:43:48 GMT

In your expression, you can use set analysis that looks like the following:

count({<[Start Date]={'>=$(=MakeDate(2013,1,1))<=$(=today())'}>}[Staff Field])

bruno_m_santos — Thu, 07 Nov 2013 13:47:56 GMT

You must use set Analysis in your expression, like this. I Suggest use variables.

Count($<Date={">=$(=Date(vDateStartP1,'DD-MM-YYYY'))<=$(=Date(vDateEndP1,'DD-MM-YYYY'))"} > Staff)

Thanks

Bruno