Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
mgomezlor
Contributor III
Contributor III

Scatter plot and Line Chart accumulated

Hi,

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.

Line chart.PNG

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.

scatter.PNG

I attach a qvf with the 2 charts.


Thank you very much in advance.

14 Replies
mgomezlor
Contributor III
Contributor III
Author

For that program it's correct but not for the rest. It should be:

   

PROGRAMDATEAmount €Accumulated
P12015-03-0123,3423,34
P22015-07-21235,44258,78
P32015-12-2556,00314,78
P42016-06-1882,87397,65
P52017-08-2419,24416,88
P52017-03-1514,53431,42
P62017-04-1012,00443,42
P72018-10-31100,84544,26
P82018-11-0419,00563,26

Line chart2.PNG

sunny_talwar

Try this

Sum(AMOUNT*(If(IsNull(FX_VALUE), 1, FX_VALUE)))


Capture.PNG

mgomezlor
Contributor III
Contributor III
Author

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

sunny_talwar

Use set analysis like this

Sum({<SetAnalysis>}AMOUNT*(If(IsNull(FX_VALUE), 1, FX_VALUE)))

mgomezlor
Contributor III
Contributor III
Author

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!