topic Pivot table and Only function issue in QlikView

Pivot table and Only function issue

Mon, 21 Oct 2013 22:21:04 GMT

Hi Guys ,

here is what my report looks like...which is what i want except one issue

I am using "Invoice.CustomerFullName" and "Invoice.Txndate" as an expression so QV is applying only() implicitly.

Every Invoice.RefNumber is unique so I get each invoice listed on my report.

The only problem that i am facing is when the item has only one invoice. for instance...Door Frame...it has only one invoice so the Total for this item also shows TxnDate and the CustomerFullname like "Vasquez, Anabel". It is happening because when only() does not find two different values then it shows the unique value.

Is there any way to get rid of this Txndate and CustomerFullname on the "Total" line even if item has only one invoice.

Re: Pivot table and Only function issue

Tue, 22 Oct 2013 02:38:34 GMT

See attached file

Regards,

Alex

Re: Pivot table and Only function issue

Tue, 22 Oct 2013 14:43:40 GMT

Thanks Alex!

It works.

I took a clue from your solution and did something like this because dimensions might change

if(RowNo()<>0 and not IsNull(RowNo()),Invoice.TxnDate)

this works too and I am not tied with dimensionality.