Using Dimension value in Measures Expression using Pivot Table

[pomaaa]

Hi,

As I am new to Qlik Sense I am struggling with writing an expression.

I have created a Pivot where my dimension is a month value from a table [invoices.month].

However, in the measures I am calling a different table however I would still like to use the month value from the dimension. I have written it like this however it is not working and I haven't managed to find a solution:

=sum({<[customer.month]={[invoices.month}>}[customer.value])

How can the value of [customer.month] be the current value of the dimension from [invoices.month]. When I write just =[invoices.month] I get the number of the month displayed, but when I use it in the expression I placed up there, it isn't working.

Thank you for the help.

[AshutoshBhumkar]

Hello,

How are both the tables connected ?

Even if you put any of the month in dimension, data will be displayed accordingly if both the tables are connected using correct key.

Could you provide any sample data to work on ?

Thanks,

Ashutosh

[pomaaa]

Hi @AshutoshBhumkar ,

The tables aren't connected. I basically want a sum of values from the "customer" table but for the month of the dimension only for one measure. In all other measures use data from "invoices" table and it's working fine.

The tables are large but basically the fields used are something like this and the IDs can't be connected:

Invoices:

InvoiceNumber	Month	Value
11112	3	12345.00
11113	4	12346.00
11114	8	12347.00
....	....	....

Customer:

CustomerNumber	Month	Value
0945	1	12345.00
0945	1	12344.00
0941	5	12333.00
...	...	...