Re: set analysis -- clarification - Page 2 - Qlik Community

Report Inappropriate Content · ‎2011-06-15

Hi All,

I am doing a Dashboard where I have to show a pivot table which has the data about the Plan Cost and Actual cost.Actual cost is working fine in the Table.I have a problem with the set analysis expression.

This is the onI have used in the chart

count({<Month_Cost = {'June'},Month= {'June 2011'},[Travel Mode] = {'Flight'}>}Cost_Targets) .I have two months in the table.

Month is the field present in the fact table.Month_cost is the field which is connected to the fact table using Region field.

I have used the

Report Inappropriate Content · ‎2011-06-15

If you are not able to find the QV document I have attached the application in the Qlikview community.please find the same with below subject line…

set analysis Clarification <http://community.qlik.com/message/124425#124425

Report Inappropriate Content · ‎2011-06-15

Yes I used all the expressions that you have mentioned. I am attaching the application again..

Anonymous · ‎2011-06-15

Like I thought, a typo 🙂

Month= {'June 2011'}

Must be

Month= {'Jun 2011'}

Report Inappropriate Content · ‎2011-06-15

I have given in the correct format… but dnt know why it is not coming… Do you have any idea about using the ONLY function here….

Anonymous · ‎2011-06-15

If you change this:

sum({<Month_Cost = {'June'},Month= {'June 2011'},[Travel Mode] = {'Flight'}>}Cost_Targets)

to this

sum({<Month_Cost = {'June'},Month= {'Jun 2011'},[Travel Mode] = {'Flight'}>}Cost_Targets)

It works, right?