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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Dima1989
Contributor
Contributor

Calculation with a selected SQL Database

Hello community,

I'm at the very beginning working with qlik and also it's the first time I'm using this forum hoping its the right place for my problem.

I have the following chart and would now like to add a third line. This line should be calculated from the two existing data. 

Dima1989_1-1669191744322.png

 

The formula is like:

=WENN(L80-(K80-K81)>0;L80-(K80-K81);0)

Dima1989_0-1669191606945.png

So, I have two data streams (one from an sql "abarbeitung" and the other from an excel "Füllstände") matching them with the Date. I need to connect the streams with an formula which should do the operation with data of two different dates. I have absolutely no idea how get get the solution for that requirement.

If you need more input from me tell me what you need.

please help me. thx.

Dima1989_0-1669191606945.png

 

Labels (3)
0 Replies