Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

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
settu_periasamy
Master III
Master III

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

View solution in original post

16 Replies
settu_periasamy
Master III
Master III

Chanty,

Can you decrease your qv size and upload it?

Chanty4u
MVP
MVP
Author

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
Partner - Champion III
Partner - Champion III

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
Master III
Master III

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

kkkumar82
Specialist III
Specialist III

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

Chanty4u
MVP
MVP
Author

still same size bro

settu_periasamy
Master III
Master III

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

Chanty4u
MVP
MVP
Author

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

maksim_senin
Partner - Creator III
Partner - Creator III

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