topic Re: Dimension Limits in QlikView

Dimension Limits

Wed, 16 Oct 2013 13:35:26 GMT

Hy,

It is possible to put a condition like "Show only values that accumulate from X to Y". Can you suggest a method to do this?

Thank You!

Re: Dimension Limits

Wed, 16 Oct 2013 13:39:06 GMT

Use set analysis, not dimension limits tab.

Re: Dimension Limits

Anonymous — Wed, 16 Oct 2013 13:41:51 GMT

Dincovici

I am don't really understand the details what you are precisely trying to achieve, but have you tried looking at the Chart object "Dimension Limit tab ?

If that is an irrelevant to your question then please clarify what you are after ?

Best Regards, Bill

Re: Dimension Limits

Wed, 16 Oct 2013 13:54:17 GMT

Yes Bill, I tried to use "dimension limits", but there I can not enter an interval. For example, I need to take values that are between 80% and 90% relative to the total, using largest values.

Re: Dimension Limits

Anonymous — Wed, 16 Oct 2013 14:02:43 GMT

Dincovici

As Thomas suggested Set Analysis could well be the way to go.

Or maybe you could try a Calculated Dimension with an if... blah, blah, blah. But beware as injudicious use of Calculated Dimensions can cause performance issues.

If could you post some sample data it would make understanding your requirement a lot easier.

Also additions to the load script can often help things like this.

Best Regards, Bill

Re: Dimension Limits

Thu, 17 Oct 2013 14:48:02 GMT

My load script is similar to:

Sellers:

LOAD

Bids_SellerId,

Bids_CatalogId,

Bids_State,

Bids_InShop,

Bids_Regdate,

Count(Bids_Id) as Bids_Count,

Sum(Bids_CurrbId) as Bids_Value

Resident

Bids

Group By

Bids_SellerId,

Bids_CatalogId,

Bids_State,

Bids_InShop,

Bids_Regdate;

I tried to create a straight table, with Bids_SellerId as dimension, ordered descending by sum (Bids_Value). Now I have to find a solution to extract a list of sellers who made between 80% and 90% of total revenue. I tried to create a dimension based on rangesum but it crashes (Error in calculated dimension). Something like:

If(RangeSum(Above(Sum(Bids_Value),0, RowNo())) > vLimit1 and RangeSum(Above(Vanzari,0, RowNo())) < vLimit2, 1, 2)

Probably I'm not allowed to use RangeSum in calculating dimensions...

The same formula used as an expression works fine, but it crashes when the dataset exceeds 100,000 records. Also used as an expression does not help me too much because I can not make a selection based on it