Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Mini Chart in Limit Dimension Issue

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

limitDimensionWindow.png

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.

limitDeminsionIssue.png

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))

11 Replies
Highlighted
Champion
Champion

Re: Mini Chart in Limit Dimension Issue

Are you sure your formula is correct?

For me it should be like this:

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

Highlighted
Not applicable

Re: Mini Chart in Limit Dimension Issue

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...

Highlighted
Not applicable

Re: Mini Chart in Limit Dimension Issue

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

Highlighted
Champion
Champion

Re: Mini Chart in Limit Dimension Issue

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

Highlighted
Champion
Champion

Re: Mini Chart in Limit Dimension Issue

On State & City what restriction you want to apply?

Highlighted
Not applicable

Re: Mini Chart in Limit Dimension Issue

Already Mention the on the First Post along with the screenshot

Highlighted
Champion
Champion

Re: Mini Chart in Limit Dimension Issue

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

Highlighted
Specialist
Specialist

Re: Mini Chart in Limit Dimension Issue

Hi,

Make Mode:Sparkline

click Supress when value is Null.

Highlighted
Not applicable

Re: Mini Chart in Limit Dimension Issue

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

limitDeminsionIssue2.png