If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I need some help with two charts. On the one hand, I have a line chart that shows the accumulated amount on each end of the month date. I have created a calendar that takes me all the previous dates of each end of the month. In the graph of lines below in original currency works correctly. In the top one I added the exchange rate and I no longer get the accumulated amount.
On the other hand, I have a scatter chart. The program P5 exists twice with different amounts and dates but only appears once and I would need to show two with the different amounts and dates.
I attach a qvf with the 2 charts.
Thank you very much in advance.
For that program it's correct but not for the rest. It should be:
it works but I need to use the variable to calculate the exchange rate. In this example i don't use set analysis but in my real app I need it because the exchange rate table has a date that i need to filter with the reporting date filtered by the user
It's not working well. I upgrade the example with that condition and with reporting date as today I dont get the expected results (I expect the same results obtained with the previous data).
I attach the new qvf.
Thank you so much for your help!