topic Re: Mini Chart in Limit Dimension Issue in QlikView

Mini Chart in Limit Dimension Issue

Wed, 30 Dec 2015 05:00:00 GMT

i have two Dimension in a Table State and City, i have put a limit Dimension on City i.e.

i have also created a MINI Chart in last of the table column in which i want to show the trend of the T/o.

when i remove limit Dimension formula its show trend in all city. but when we put the Limit Dimension back is show me blank few City.

the Trend Dimension is MonthYear.

trend Formula:

(Sum({<MONTHYEAR=>} TRADE_VALUE)/sum({<MONTHYEAR=>} TRADING_DAYS))

Re: Mini Chart in Limit Dimension Issue

Anonymous — Wed, 30 Dec 2015 05:28:13 GMT

Are you sure your formula is correct?

For me it should be like this:

=(Sum({<MONTHYEAR=>} TRADE_VALUE)/count({<MONTHYEAR=>} distinct TRADING_DAYS))

Re: Mini Chart in Limit Dimension Issue

Wed, 30 Dec 2015 05:34:34 GMT

Hi Balraj,

Formula is Correct because i have a table where i have keep MONTHYEAR, TRADING_DAYS for example.

MONTHYEAR, TRADING_DAYS

NOV-2015, 20

for Daily Avg Calculation i have to do like this only.. other place i am doing this way only..

Its a just matter of deriving value...

Re: Mini Chart in Limit Dimension Issue

Wed, 30 Dec 2015 05:35:45 GMT

Even if i do only SUM() then also facing the problem. but when i remove the Dimension Limit its working fine.

Re: Mini Chart in Limit Dimension Issue

Anonymous — Wed, 30 Dec 2015 05:41:57 GMT

okay, so what dimension limit you are trying to achieve?

Re: Mini Chart in Limit Dimension Issue

Anonymous — Wed, 30 Dec 2015 05:42:40 GMT

On State & City what restriction you want to apply?

Re: Mini Chart in Limit Dimension Issue

Wed, 30 Dec 2015 05:44:17 GMT

Already Mention the on the First Post along with the screenshot

Re: Mini Chart in Limit Dimension Issue

Anonymous — Wed, 30 Dec 2015 05:46:54 GMT

did you try with suppress with null option for City Dim?

Re: Mini Chart in Limit Dimension Issue

ajsjoshua — Wed, 30 Dec 2015 05:49:38 GMT

Hi,

Make Mode:Sparkline

click Supress when value is Null.

Re: Mini Chart in Limit Dimension Issue

Wed, 30 Dec 2015 05:55:30 GMT

Already check that no problem with that... I think it is related to Limit Dimension only because when i remove Limit Dimension its showing mini Graph for all city.

Image After removing Limit Dimension.... Now it showing all

Re: Mini Chart in Limit Dimension Issue

Anonymous — Wed, 30 Dec 2015 06:03:37 GMT

So, its very much clear that City with no value are not matching with your restriction which is like 80 % relative of the toal largest value.

City are not having 80 % relative of the toal largest value, will not display

Re: Mini Chart in Limit Dimension Issue

derekjones — Fri, 05 Feb 2016 16:35:46 GMT

Hi Jitendra

I'm facing exactly the same issue, did you ever get a resolution to this? If not should we raise it as a bug?

Best regards

Derek