Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Pivot table with conditional expressions

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.

5 Replies

Re: Pivot table with conditional expressions

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

HIC

Not applicable

Re: Pivot table with conditional expressions

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.

nagaiank
Valued Contributor III

Re: Pivot table with conditional expressions

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

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

Not applicable

Re: Pivot table with conditional expressions

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.

Not applicable

Re: Pivot table with conditional expressions

Any other suggestions pls