Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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 |
... | ... | ... |