topic Re: RE:Line Chart-Issue in QlikView

RE:Line Chart-Issue

Chanty4u — Mon, 04 Apr 2016 05:00:21 GMT

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.

Re: RE:Line Chart-Issue

settu_periasamy — Mon, 04 Apr 2016 05:04:13 GMT

Chanty,

Can you decrease your qv size and upload it?

Re: RE:Line Chart-Issue

Chanty4u — Mon, 04 Apr 2016 05:05:33 GMT

Hi,

I have deleted all the script but.

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

Re: RE:Line Chart-Issue

jonathandienst — Mon, 04 Apr 2016 05:06:10 GMT

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

Re: RE:Line Chart-Issue

settu_periasamy — Mon, 04 Apr 2016 05:13:46 GMT

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

Re: RE:Line Chart-Issue

kkkumar82 — Mon, 04 Apr 2016 05:21:54 GMT

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

Re: RE:Line Chart-Issue

Chanty4u — Mon, 04 Apr 2016 05:27:03 GMT

still same size bro

Re: RE:Line Chart-Issue

settu_periasamy — Mon, 04 Apr 2016 05:43:22 GMT

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

Re: RE:Line Chart-Issue

Chanty4u — Mon, 04 Apr 2016 05:46:47 GMT

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

Re: RE:Line Chart-Issue

maksim_senin — Mon, 04 Apr 2016 06:41:40 GMT

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

Re: RE:Line Chart-Issue

Chanty4u — Thu, 07 Apr 2016 05:20:16 GMT

Hi settu_periasamy

i have some issue again in the same ....

I have updated my Qvw and attached in first discussion with date.

in that i have two tabs lik :Rejection Tracer till aug2015 and Rejection traker.

The issue is... what evere the first tab hvng the charts till aug2015. same visualization i need in next tab from sep2016 to till date. [i.e . rej tracker].

i hve tried but getting negative quarters .. Please look into that and update if anythng required.

Re: RE:Line Chart-Issue

HirisH_V7 — Thu, 07 Apr 2016 05:32:40 GMT

Hi,

It will be based on your data and your expressions defined.

Can you make a simple sample describing your issue!

-Hirish

Re: RE:Line Chart-Issue

HirisH_V7 — Thu, 07 Apr 2016 06:08:30 GMT

Hi,

This is due to in corporate expression your grouping the quantity using aggr and yours business logic is like that i hope,

so its effecting the chart,

Do check your data model , and business logic too will help you.

Here the Corporate expression was disabled then the output is like this,

HTH,

Hirish

Re: RE:Line Chart-Issue

Chanty4u — Thu, 07 Apr 2016 06:17:02 GMT

the abve issue was cleared Hirish.

i was updated qvw again ...in that am facing the issue. attached in above .... Pro_07-04-2016.qvw.

Re: RE:Line Chart-Issue

settu_periasamy — Thu, 07 Apr 2016 07:36:18 GMT

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

Re: RE:Line Chart-Issue

Chanty4u — Thu, 07 Apr 2016 08:28:45 GMT

i will chk nd come back to u Settu. Thanks.

Re: RE:Line Chart-Issue

Chanty4u — Fri, 08 Apr 2016 10:31:03 GMT

Hi settu_periasamy,

In that chart ....what ever the selections v hve East and west....lik dat it is showng single line in chart thats fine....

Problem: But individually values it is showng correct..

if i select multi values from filter... the chart line values not showing exctly.?

What is the problem may i know?chk below image