topic Re: Pivot table with conditional expressions in QlikView

Pivot table with conditional expressions

Wed, 14 Oct 2015 14:12:09 GMT

Hi Experts,

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.

Re: Pivot table with conditional expressions

hic — Wed, 14 Oct 2015 14:19:06 GMT

I suspect that the inner join causes record duplication. Remove it and see if that makes a difference.

Re: Pivot table with conditional expressions

Wed, 14 Oct 2015 14:30:15 GMT

Hi henric,

i tried removing the join, again i m not getting correct values other than the two tables i mentioned.

Pls give some other suggestions.

Re: Pivot table with conditional expressions

nagaiank — Wed, 14 Oct 2015 14:43:48 GMT

Did you try using 'Concatenate' instead of 'Inner Join' ?

In your inner join, only field common to both tables is PNO.

Re: Pivot table with conditional expressions

Wed, 14 Oct 2015 14:48:28 GMT

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.

Re: Pivot table with conditional expressions

Thu, 15 Oct 2015 08:46:50 GMT

Any other suggestions pls