topic Box plot not showing values for complete dimension list? urgent help please!!! in QlikView

Box plot not showing values for complete dimension list? urgent help please!!!

Fri, 05 Feb 2016 20:31:11 GMT

Hi,

Box plot is not showing for complete dimension. only for one dimension box plot is showing values. remaining values are not showing.

Dimension : =Valuelist('AA','BB','CC','DD')

expression1:

Box Plot middle =Dual(
Fractile(Aggr([AA],[BB],[CC],[DD]), 0.5)&Chr(13)
&'Box Plot Bottom = '&Fractile(Aggr([AA],[BB],[CC],[DD]), 0.25)&Chr(13)
&'Box Plot Top = '&Fractile(Aggr([AA],[BB],[CC],[DD]), 0.75)&Chr(13)
&'Box Plot Lower Whisker = '&Fractile(Aggr([AA],[BB],[CC],[DD]), 0.05)&Chr(13)
&'Box Plot Upper Whisker = '&Fractile(Aggr([AA],[BB],[CC],[DD]), 0.95)&Chr(13)
,Fractile(Aggr([AA],[BB],[CC],[DD]), 0.75)-Fractile(Aggr([AA],[BB],[CC],[DD]), 0.25))

expression2:

Box plot Top : Fractile(Aggr([AA],[BB],[CC],[DD]), 0.75)
Box plot Bottom : Fractile(Aggr([AA],[BB],[CC],[DD]), 0.25)
Box Plot Middle : Fractile(Aggr([AA],[BB],[CC],[DD]), 0.5)
Box Plot Lower Whisker : Fractile(Aggr([AA],[BB],[CC],[DD]), 0.05)
Box Plot Upper Whisker : Fractile(Aggr([AA],[BB],[CC],[DD]), 0.95)

expression3:

Upper Outliers : min(Aggr([AA],[BB],[CC],[DD]))

expression4:

Upper Outliers : max(Aggr([AA],[BB],[CC],[DD]))

Box plot is showing values only for AA. remaining BB,CC,DD nothing showing in chart.

please can anyone suggest me is there any wrong in above dimension and expressions and how to sort the issue.

Thanks.

Re: Box plot not showing values for complete dimension list? urgent help please!!!

swuehl — Fri, 05 Feb 2016 21:02:58 GMT

You are using a synthetic dimension using ValueList(), but you are never testing on the synthetic dimension value in your expression. What do you want to achieve with thìs construction?

You are probably seeing only values for 'AA', since the advanced aggregation with its default DISTINCT qualifier will return only values for the first dimension values in load order, which is 'AA' (also known as grain mismatch in HICs blog post about aggr() pitfalls, which I referenced in your other thread).

You can try adding NODISTINCT qualifier to your aggr() functions, but honestly, I have no idea what you are trying to do (using the advanced aggregation and in general).

Hence I would suggest, that you add context to your request.

Re: Box plot not showing values for complete dimension list? urgent help please!!!

Fri, 05 Feb 2016 21:06:41 GMT

Thanks. I am first time using box ploy so I used the expressions that I found in blog. so, I have no idea of where I need to use NODISTINCT.

Please can you suggest me where do I need to use NODISTINCT

Thanks.

Re: Box plot not showing values for complete dimension list? urgent help please!!!

swuehl — Fri, 05 Feb 2016 21:16:17 GMT

Like this:

Aggr(NODISTINCT [AA],[BB],[CC],[DD]),

you can add the NODISTINCT qualifier to all Aggr() function.

If I read your post correctly, I assume you will get the same box plot for every synthetic dimension value, then.

Re: Box plot not showing values for complete dimension list? urgent help please!!!

Fri, 05 Feb 2016 21:25:17 GMT

Thanks. used NODISTINCT in all Aggr() but still box plot not showing