topic Re: Split logic in straight table in QlikView

Split logic in straight table

abc_18 — Tue, 16 Feb 2016 10:24:36 GMT

Hi Team,

I am using a straight table with dimensions and expressions.

I am comparing two fields ’ vendor_split and ID vendor from two different table, and replacing Proforma Invoice NO with id row if it is NULL.

My expression for Amount LCY with Split column is :-

IF(([Proforma Invoice No] = 'Null' and Vendor_Split = 0) ,(split*total_amount_fct)/100

,if(([Proforma Invoice No ]= 'Null' and Vendor_Split = idvendor), (split*total_amount_fct)/100

)

Required o/p:-

1> if vendor_split=idvendor then only that particular row should come .means only one row

2> if vendor_split<> idvendor then records with zero value from vendor_split should come.

Re: Split logic in straight table

PradeepReddy — Tue, 16 Feb 2016 11:26:47 GMT

can you share sample application?

Re: Split logic in straight table

hic — Tue, 16 Feb 2016 11:56:00 GMT

First, you cannot use

[Proforma Invoice No ]= 'Null'

Instead you should use one of the following

IsNull([Proforma Invoice No ])

Len(Trim([Proforma Invoice No ]))= 0

Secondly, you should not use naked field references. The calculations are aggregations, so you need to wrap field references in aggregation functions. See Use Aggregation Functions!

HIC

Re: Split logic in straight table

NareshGuntur — Tue, 16 Feb 2016 12:04:10 GMT

Hi Shikha,

Your query seems confusing. You better load a sample data(a few rows with values changed) and attach the document here to gain much attention.

Cheers,

Naresh