Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sureshqv
Esteemed Contributor III

RE:Line Chart-Issue

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.

1 Solution

Accepted Solutions

Re: RE:Line Chart-Issue

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

Capture.JPG

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

16 Replies

Re: RE:Line Chart-Issue

Chanty,

Can you decrease your qv size and upload it?

sureshqv
Esteemed Contributor III

Re: RE:Line Chart-Issue

Hi,

I have deleted all the script but.

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

MVP
MVP

Re: RE:Line Chart-Issue

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

Re: RE:Line Chart-Issue

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

kkkumar82
Valued Contributor III

Re: RE:Line Chart-Issue

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

sureshqv
Esteemed Contributor III

Re: RE:Line Chart-Issue

still same size bro

Re: RE:Line Chart-Issue

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

sureshqv
Esteemed Contributor III

Re: RE:Line Chart-Issue

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

maxim_senin
Contributor III

Re: RE:Line Chart-Issue

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

Community Browser