Solved: Re: RE:Line Chart-Issue - Qlik Community

Chanty4u · ‎2016-04-04

Hi all,

settu_periasamy

I have some issue in Bar chart.

As i have a list box values lik

East

south

north

west.

wen i select any one of above in my chart that line will show in chart. that is fine.

REQ: but when i select any Two its showing 3lines in chart..

means i select East and South . its giving East and south and north aswell

Please find the sample below.

Thanks in advance.

settu_periasamy · ‎2016-04-07

I think, it may be problem with your already loaded QVD. It may be blank in your Year values and only stored

'-'(hyphen) with Quarter value..

check the table Rejections2016

WHEAT_REJ_YEAR &'-'& WHEAT_REJ_QUATER As WHEAT_REJ_QUATERYEAR1

In the above, May be WHEAT_REJ_YEAR is blank when you create a Table

View solution in original post

settu_periasamy · ‎2016-04-04

Chanty,

Can you decrease your qv size and upload it?

Chanty4u · ‎2016-04-04

Hi,

I have deleted all the script but.

I dont hve Reload Option for this qvw Bro.... Is there any other way to Reduce?

jonathandienst · ‎2016-04-04

Use this as a guide to data reduction for the forum: Preparing examples for Upload - Reduction and Data Scrambling

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

settu_periasamy · ‎2016-04-04

May be create your own example (dimension and expression values - with the problem) instead of the entire data..

kkkumar82 · ‎2016-04-04

To decrease file size, select any one or two values in the list box and goto File Menu->Reduce Data->Keep possible values.

Chanty4u · ‎2016-04-04

still same size bro

settu_periasamy · ‎2016-04-04

There are so many tabs.. Which tab you are talking about?

Chanty4u · ‎2016-04-04

In script ..it is totally relates to Wheat Tab only.

maksim_senin · ‎2016-04-04

Hi,

Reasons:

1. When only one Region is selected it is values are actually equal to cumulative ones which are aggregated into Corporate expression

2. The Corporate expression is always calculated and has non-zero values

What I think:

1. I'm not sure the Corporate has any meaning with current logice since it's only accumulates values which are in current selections. So you need either to change it's logic in order to calculate in over all regions (real Corporate) or to just rename it to Total

2. In case you really don't need it when not all regions are in current selections, just make it conditionally shown

Best regards,

Maxim