topic Re: chart help. urgent plsssss help in QlikView

chart help. urgent plsssss help

Tue, 22 Sep 2015 17:09:53 GMT

Hi Expert,

i have attached the sample qvw.

i have two tables in that as per my requirement.

but two tables showing different values on expression.

i have selected a particular product for example.

i need to total products going from location1 to location2 on one day and how many returned from location2 to location1 from next day.

but both tables should have same values.

Please help me on this.

Re: chart help. urgent plsssss help

Clever_Anjos — Tue, 22 Sep 2015 19:32:40 GMT

You application has only one table and no graph.

Maybe you attached before saving

Re: chart help. urgent plsssss help

Clever_Anjos — Tue, 22 Sep 2015 19:35:48 GMT

Re: chart help. urgent plsssss help

Anonymous — Tue, 22 Sep 2015 19:38:17 GMT

curious effect

with fit zoom to window you wull see the two tables

Re: chart help. urgent plsssss help

Tue, 22 Sep 2015 19:53:39 GMT

Click on that Search object. You will see two tables

Re: chart help. urgent plsssss help

cjohnson — Tue, 22 Sep 2015 20:26:47 GMT

Perhaps this is a silly question but why are the AGGR's needed in the first table? Can you not have expressions as follows:

SUM(ORDQTY)

SUM(REORDQTY)

Re: chart help. urgent plsssss help

Wed, 23 Sep 2015 07:36:04 GMT

Hi Camile,

if i remove the aggr in the first table, it is showing wrong values as like second table.

the first table value is correct.

i want the same values for the second table.

pls help me to solve this

Re: chart help. urgent plsssss help

cjohnson — Thu, 24 Sep 2015 02:14:03 GMT

Hi,

I'm not sure what the intent is (I'm not sure what you're actually trying to show), but if it's simply trying to get the two tables to match please see attached.

If you remove the external SUM from your expression in the straight table it will match the value of your pivot table as shown below:

Would you mind elaborating more on the intent of this?

Thanks,

Camile

Re: chart help. urgent plsssss help

Fri, 25 Sep 2015 07:39:54 GMT

thanks a lot camile