Discussion board where members can get started with QlikView.
I have attached a sample qvw.
i did inner join of two tables in the script.
we have different products & different branches.
i need to count the no. of products sent from one branch to wholesale store on a particular day and again how many of the same product is returned back to the same branch in the next 7 days.
In the attached file, i have three tables.
first two tables- detailed & test view are showing correct values. but the summary table is not correct.
i dont know how to correct the expressions.
Also i need to correct the charts as well.
please help me on this.
I suspect that the inner join causes record duplication. Remove it and see if that makes a difference.
See also To Join or not to Join
i tried removing the join, again i m not getting correct values other than the two tables i mentioned.
Pls give some other suggestions.
Did you try using 'Concatenate' instead of 'Inner Join' ?
In your inner join, only field common to both tables is PNO.
i cant use concatenate. i purposely did inner join as per the requirement.
no prob on the joins.
i need to correct the table & charts.
in the first two table dimensions, i have given conditions for To Date & RE order no. this is because of the requirement.
Any other suggestions pls