Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Restrict dimension causes the sequence of barchart not group by dimension

Dear All,

Why when I Restrict Dimension in bar chart, the result/graphic not join in dimension.

Is there any other way to get the graphs accumulated in each Dimension ?


Thanks


Graph in month Dimension not collect in group

data1.png


10 Replies
Highlighted
Specialist II
Specialist II

Re: Restrict dimension causes the sequence of barchart not group by dimension

Hi,

I don't see how to change it with parameters,

another way is to put it in dimension as :

instead of type :

if(aggr(rank(sum('your field')),month,type)>=4,type)

regards

Highlighted
Partner
Partner

Re: Restrict dimension causes the sequence of barchart not group by dimension

can you post a sample...

Highlighted
Contributor
Contributor

Re: Restrict dimension causes the sequence of barchart not group by dimension

Hi Kuwar,

This is a sample

If I am not using Dimension Limit, the graph is okey

bar charts separate by dimension (month)

But, if I using restrict dimension, there are several separate bars when in 1 dimension

Highlighted
Partner
Partner

Re: Restrict dimension causes the sequence of barchart not group by dimension

Hi,

Might be there is Section Access applied in your QVW i cannot access the properties of the objects.

Regards,

Sudhir

Highlighted
Partner
Partner

Re: Restrict dimension causes the sequence of barchart not group by dimension

Please try this....

4.PNG

Highlighted
Contributor
Contributor

Re: Restrict dimension causes the sequence of barchart not group by dimension

Thank's kuwar

But how if I want show graph with 3 largest value example ?

Highlighted
Partner
Partner

Re: Restrict dimension causes the sequence of barchart not group by dimension

then it will show only largest 3 TYPE in chart

But why you want to apply dimension limit on TYPE....?

Highlighted
Contributor
Contributor

Re: Restrict dimension causes the sequence of barchart not group by dimension

Well,

I Want to know for example what 3 biggest problems in shown every month ?

as look at an example,
the first month 3 the biggest problems are C, E, D
then the second month A, D, C and the third month A, E, C

When I use First restrict, the type that will be in view for each month is type A, B, C.

whereas in the first month the biggest type is C, E, D

if I using Largest Restrict, there is a bar that separates when it's in the same month


Note:

I am using Qlikview Version 11.20.12451.0 SR7 64bit

data2.png



Highlighted
Partner
Partner

Re: Restrict dimension causes the sequence of barchart not group by dimension

1. When I use First restrict, the type that will be in view for each month is type A, B, C.

whereas in the first month the biggest type is C, E, D-- First restrict will show you first N TYPE in month. Then obviously it will show TYPE A,B,C


2. if I using Largest Restrict, there is a bar that separates when it's in the same month-- Largest restrict will the biggest N TYPE in the month. So it is showing TYPE C,D,E for Month 1 and will skip the space for TYPE A and B so it looking separate to you


What exactly you wanted to show.....? Largest or First