straight table expression

savithri_n_s — Sat, 03 Mar 2018 08:15:10 GMT

Hi,

I have 2 tables. One is Spend table and another is contractor table. I am trying to link the data of both the table in Straight table

in sheet 5 of attached Qvw

I am getting same values in the row highlighted below. Can you please help what is wrong here?

Your help is greatly appreciated

Regards,

Savithri

Message was edited by: savithri Ns Thank you . Can you please tell me how can we write expression to get sum[Spend USD2] where [Preferred Supplier] column is non blank And also Can you please tell me how can we add FY18 Average based over calculated expression in dashboard 5 of qvw

Re: straight table expression

settu_periasamy — Mon, 05 Mar 2018 05:37:35 GMT

The two table's are connected with 'country' field. But, you have Calendar field also.

When you put a dimension as Calendar field(MonthYear), It will give the total value.

Try to change the keyfield like country & YearMonth.

topic straight table expression in QlikView

straight table expression

Re: straight table expression