Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
savithri_n_s
Contributor III
Contributor III

straight table expression

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

1 Reply
settu_periasamy
Master III
Master III

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.

Capture.JPG