topic Re: Set Analysis - Dimension problem in QlikView

Set Analysis - Dimension problem

Thu, 28 Feb 2013 13:37:51 GMT

I have a problem with SetAnalysis where he is only considering the last Type2 of table, not respecting the selection of Type2 showing the sum of the last

Type2 in all dimensions ... Does anyone know what the problem ? Thanks.

Expression: Count({$<Table1.Type = Type, Table1.Type2 = {$(=Maxstring([Type2]))} >} Distinct Table1.Key_Employee ) ) )

Re: Set Analysis - Dimension problem

Gysbert_Wassenaar — Thu, 28 Feb 2013 13:47:14 GMT

Count({$<Table1.Type = Type,

If Type is a dimension in your chart then you can't use it in the set analysis expression. If Type is a field and there is only one value selected you need to change it to Table1.Type = {'$(=only(Type))'}

Table1.Type2 = {$(=Maxstring([Type2]))} >} Distinct Table1.Key_Employee ) ) )

Same here. If Type2 is a dimension in your chart you can't use it in the set analysis expression. If it is a field then enclose it in single quotes.

Table1.Type2 = {'$(=Maxstring([Type2]))'}

It's also not clear to me if Table1.Type is the same field as Type or a field from another table.

Re: Set Analysis - Dimension problem

Thu, 28 Feb 2013 14:24:07 GMT

Thanks for the Reply...

Type is a field of another table...