topic Re: Dimension being ignored in Set Analysis with operand in QlikView

Dimension being ignored in Set Analysis with operand

Thu, 20 Dec 2012 10:18:53 GMT

Hi Guys,

I have a set analysis expression which uses the union operand ("+") to identify unique Order Numbers that may be affected by errors from 2 areas.

Count({$<FOCGroupClass = {'Damaged'}>+<[Credit Reason] = {'Damaged Goods'}>}DISTINCT [Order Number])

We have a field called FOCGroupClass which indicates whether the Order was damaged, and similarly, we have a field called CreditReason which will also capture where an Order has been damaged. I need to count the unique Order numbers that have been affected which the above expression does very nicely within a table.

However, when i wish to use this in a chart with a week dimension and a year dimension, the Year dimension is being ignored.

Is there another aspect that needs to be included in the Set Analysis to take this into consideration?

Hope this is clear, if not, i can attach the file.

Thanks,

Nick

Re: Dimension being ignored in Set Analysis with operand

jagan — Thu, 20 Dec 2012 10:24:51 GMT

Hi,

Can you attach the sample file.

Regards,

Jagan.

Re: Dimension being ignored in Set Analysis with operand

Thu, 20 Dec 2012 11:00:26 GMT

Not a problem,

Please find enclosed.

Thanks for your help

Nick

Re: Dimension being ignored in Set Analysis with operand

Gysbert_Wassenaar — Thu, 20 Dec 2012 11:07:45 GMT

As far as I know you can use only one dimension in a line chart. There's only one x-axis after all. What do you expect to see in the chart?

Re: Dimension being ignored in Set Analysis with operand

Thu, 20 Dec 2012 11:14:56 GMT

I was hoping that it would create separate lines for each year such as;

I'm assuming this doesn't happen since i have more than one expression in the other chart? Is there anyway i could create the above image with multiple expressions as well?

Re: Dimension being ignored in Set Analysis with operand

Gysbert_Wassenaar — Thu, 20 Dec 2012 11:24:37 GMT

Yeah, a line chart is limited to two dimension + one expression or one dimension + any number of expressions. You could create more expressions for every year-supplier combination. But you might as well create that as a calculated dimension: supplier&'-'&year

Re: Dimension being ignored in Set Analysis with operand

sivarajs — Thu, 20 Dec 2012 11:25:54 GMT

check the sample this might be you expected

Re: Dimension being ignored in Set Analysis with operand

Thu, 20 Dec 2012 11:30:03 GMT

Thanks Sivaraj but that then hides the split by Supplier.

I have taken Gysbert's advice and have built an expression for each year.

Thanks everybody for their help.

Nick