topic Re: Error in Set Analysis in QlikView

Error in Set Analysis

Tue, 21 Oct 2014 14:03:29 GMT

Hello Everybody,

I have used set analysis in my expression for chart.

round(sum({$<WeightedUnweighted.= {'Weighted'},[Probability Group.]={'Open'},Year.= >}RevPreAmount.)/1000000,'0.01')

I am getting an error message when hovering over any of the bar charts.

Is there anything wrong in the expression.

Please find the attached screenshot for the same.

Thanks In Advance

Sonali

Re: Error in Set Analysis

ali_hijazi — Tue, 21 Oct 2014 14:05:56 GMT

i think you shouldn't put single quotes around 0.01

Re: Error in Set Analysis

Tue, 21 Oct 2014 14:10:41 GMT

Hi,

Try to use this things

Round(sum({$<[WeightedUnweighted.]= {'Weighted'},[Probability Group.]={'Open'},[Year.]= >}[RevPreAmount.])/1000000,'0.01')

Round(sum({$<[WeightedUnweighted.]= {'Weighted'},[Probability Group.]={'Open'},[Year.]= >}[RevPreAmount.])/1000000,0.01)

Keep the dimensions and measures in brackets.

Re: Error in Set Analysis

Tue, 21 Oct 2014 14:11:13 GMT

HI Ali,

Removed single quotes still I am getting the same error.

Re: Error in Set Analysis

Tue, 21 Oct 2014 14:15:10 GMT

HI Rakesh,

Tried both still getting same error

Re: Error in Set Analysis

jyothish8807 — Tue, 21 Oct 2014 14:20:05 GMT

Hi Sonali,

Try without Round an see if output is coming?

sum({<[WeightedUnweighted.]= {'Weighted'},[Probability Group.]={'Open'},[Year.]= >}[RevPreAmount.])/1000000

Regards

Re: Error in Set Analysis

rustyfishbones — Tue, 21 Oct 2014 14:23:20 GMT

What Dimension are you using?

Could there be an issue with the Dimension or the underlying Data

Re: Error in Set Analysis

Anonymous — Tue, 21 Oct 2014 14:24:03 GMT

Try using this expr:

Round(sum({$<[WeightedUnweighted.]= {'Weighted'},[Probability Group.]={'Open'},[Year.]= >}[RevPreAmount.])/1000000)

and in the Number Tab:For this expression check the Fixed to option and write '2' in the box provided for the no of digits after the decimal point

Re: Error in Set Analysis

Tue, 21 Oct 2014 14:32:27 GMT

Hi Alan,

In Dimention I am using the expression:
=if([Effective Date.] >= $(vEffQtr) and [Effective Date.] < $(vEffQtrTill), [Qtr Year.])

where

vEffQtr= Date('01/' &
if( (Ceil(month(MonthEnd(Today())/3)))=1,'01',
if( (Ceil(month(MonthEnd(Today())/3)))=2,'04',
if( (Ceil(month(MonthEnd(Today())/3)))=3,'07','10'))) & '/' & year(today()) )

and
vEffQtrTill= AddMonths($(vEffQtr),12)

Re: Error in Set Analysis

rustyfishbones — Tue, 21 Oct 2014 14:39:40 GMT

your problem is your dimension, however I am not sure what part is the problem

create a text object and add =Round(sum({$<[WeightedUnweighted.]= {'Weighted'},[Probability Group.]={'Open'},[Year.]= >}[RevPreAmount.])/1000000)

Let me know if text objects returns the correct result with no error?

Regards

Alan

Re: Error in Set Analysis

Tue, 21 Oct 2014 14:51:07 GMT

Hi Alan,

Yes, the text object is returning the correct result without any error.

Re: Error in Set Analysis

Anonymous — Tue, 21 Oct 2014 14:58:56 GMT

Hi sonali,

Did u try the above Solution???

Re: Error in Set Analysis

Tue, 21 Oct 2014 15:35:05 GMT

HI Karthigayan,

I tried it this. This is also giving me the same error message.

Re: Error in Set Analysis

kuba_michalik — Tue, 21 Oct 2014 18:55:26 GMT

You could just input some static label for the dimension on the Dimensions tab of chart properties. It seems QV trying to use that calculated dimension formula as the label is the only problem, after all the dimension values themselves on that axis seem fine.

Re: Error in Set Analysis

Anonymous — Tue, 21 Oct 2014 20:25:55 GMT

Are you using any calculated dimensions? If the expression correctly evaluates outside the chart, there is likely something else at play here that is causing you pain.

Try temporarily disabling this expression and putting in something simple. Does it work?

Re: Error in Set Analysis

Wed, 22 Oct 2014 08:44:38 GMT

Thanks Jakub.

Thank you for your help. It's working now.