topic gauge issue in QlikView

gauge issue

marikabi — Wed, 25 Nov 2020 16:16:04 GMT

Hello Guys,

I am trying to use a gauge chart, in order to estimate to total amount of ranges we have.

My data source is composed by different columns and I want to group my data NOT using all of them.

It means that I want to calculate the sum(Range) only for those records where [Total Range]>9, grouped by the dimensions:

Country, City, Product and Number Type.

To give you an idea, if I don't put any condition, I obtain 19850, because there are other columns in the excel source that I don't want to consider. Instead, I should obtain 16589 (I am able to calculate it using a table, where I can put the different dimensions).

Any idea, suggestion?

Many thanks in advance,

Brgrds

Re: gauge issue

sureshsindhigi — Sun, 09 Apr 2017 17:52:52 GMT

Hi Marika,

Can you please share the sample QVW file which you're working on that.

Regards,

Suresh Sindhigi.

Re: gauge issue

marikabi — Sun, 09 Apr 2017 18:00:50 GMT

Hi,

you can find attached an extract of the data source I am using.

This is the loading script:

LOAD [country prefix], [country code], [country name] as Country , [city zone] AS City , [number type] as [Number Type], product as Product,

portability, carrier as Carrier, [count booked] , [count configured], [count free], [count reserved],

[count out], [count other], production_date AS Date , ([count booked] + [count configured] + [count free] +[count reserved] +

[count out] + [count other]) as [Total Range], (1) as Range

FROM ....

I can't post the qvw application, because I am still using the personal license (an not the client one)..

Thank you

Re: gauge issue

marikabi — Mon, 10 Apr 2017 09:07:42 GMT

Hello,

any update?

I am getting crazy

Once again thank you

Re: gauge issue

Anil_Babu_Samineni — Mon, 10 Apr 2017 09:59:00 GMT

Here, The Sum(Range) showing only 8863 for me.

When you talk about you don't want to consider other table Values then use NoConcatenate