topic Re: Help on Scatter/Grid in QlikView

Help on Scatter/Grid

Tue, 18 Nov 2014 06:50:49 GMT

HI All,

I have two scenarios:

1st Case:

I have a field called ABS.

In the Bubble chart on X axis i should show the Location and Y axis is Category.

Bubble size is Count of the Products. But when user selects a value from the field ABS then the bubble size should be count of the Parts which are having ABS more than or equal to selected ABS value.

2nd case :

When user selects Selected range of values from ABS then the Bubble size should be Count of products which fall under the selected range of ABS.

Can anyone help me on this?

More over should I go for Scatter chart or Grid Chart?

Re: Help on Scatter/Grid

mdmukramali — Tue, 18 Nov 2014 07:00:11 GMT

Dear,

Can you attache the sample file. so that it's easy to help you.

Thanks,

Mukram

Re: Help on Scatter/Grid

Tue, 18 Nov 2014 07:13:32 GMT

HI Ali,

I am unable to attach the file.

AM i not clear on the requirement?

Just I need how to handle the situation.

BR,

Neehu

Re: Help on Scatter/Grid

rubenmarin — Tue, 18 Nov 2014 08:18:18 GMT

Hi, if I correctly understand this, you only need to add conditional expressions fro the 3rd expression (bubble size):

Condition: GetSelectedCount(ABS)=0

Expression: Count(Distinct Product)

Condition: GetSelectedCount(ABS)=1

Expression: Count({<ABS={">=$(=ABS)"} Distinct Product)

Condition: GetSelectedCount(ABS)>1

Expression: Count({<ABS={">=$(=Min(ABS))<=$(=Max(ABS))"} Distinct Product)

Re: Help on Scatter/Grid

Tue, 18 Nov 2014 09:17:04 GMT

HI Marin,

I am using the below expression but it is not working. Giving an error. ANy syntax error I am making?

= IF( GetSelectedCount(ABS)=0 , Count(Product),

IF( GetSelectedCount(ABS)=1, Count({<ABS={">=$(=ABS)">} Product),

IF(GetSelectedCount(ABS)>1 , Count({<ABS={">=$(=Min(ABS))<=$(=Max(ABS))">} Product))))

The error I am getting in the chart is

"Error in set modifier ad hoc element list: ',' or ')' expected"

Re: Help on Scatter/Grid

Tue, 18 Nov 2014 09:31:16 GMT

Hi Marin,

Got the issue. Missing "}". Thank s a lot