topic Re: Calculated Gross Margin Row in QlikView

Calculated Gross Margin Row

Tue, 05 Nov 2013 15:29:37 GMT

Hi :

I am trying to create a report that will show the Gross Margin,

The Sales & COS Category are obtained from the source data with the help of SQL statement, but finding it difficult to insert a "Row" (not column) in the pivot table that will subtract the COS from Sales and show the Gross Margin by Month.

I tried creating an inline table, but the Gross Margin is pushed to the end and does not allocate by Month.

(Sample data in attached excel file)

Appreciate any help in solving this issue.

thanks

Kumar

Have added a new sheet with a sample source data

thanks

Re: Calculated Gross Margin Row

Gysbert_Wassenaar — Tue, 05 Nov 2013 15:56:34 GMT

Can you post an excel file with source data too?

Re: Calculated Gross Margin Row

Tue, 05 Nov 2013 16:19:13 GMT

Have added a new sheet with a sample source data

Re: Re: Calculated Gross Margin Row

Gysbert_Wassenaar — Tue, 05 Nov 2013 16:50:55 GMT

See attached qvw for one solution.

Re: Calculated Gross Margin Row

Tue, 05 Nov 2013 19:58:35 GMT

Thanks Gysbert, it worked appreciate the help