Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

ComboChart not displaying all dates in data with different date frequency - Stock price and transaction analysis


I'm using ComboChart to publish stock prices over time (as line) and transactions (as bar charts) . The date for the stock prices is on continuous scale to avoid getting scroll bar on the chart when exploring long history of data.

The stock price data is more granular than the transactions data, i.e. the stock price data is every working day but the transactions are just once in a while.

While adding measures to the ComboChart everything looks fine when I have only added the stock price data (see picture 1). I.e. you can see prices for every day.  When the transactions are added a detail from the stock prices get lost, i.e. you stop seeing price for every day, you only see changes between the days that has some transactions (see picture 2). When this happens the analysis loses very important details that is trying to be captured.

This can be seen when the bar charts are changed to circles (see picture 3), then you can see that the stock price data is only connected between dates that transactions are on.

1) Do you know if it's possible to fix this problem?

2) If not, do you know any other charts that can do the same for me?

3) Don't you think that normal behavior of the ComboChart would be to show every day of the stock price?

I've attached an app and data that shows the problem I'm having.

Picture 1: Only stock price

Only stock price.JPG

Picture 2: Stock price and transactions

Stock price and transactions.JPG

Picture 3: Transactions shown as circles.

All data points.JPG

1 Reply
Contributor II
Contributor II

If the expressions are changed to following then fewer points shown on the graph but the detail in the line is still missing.

if(TransactionType='BUY', SUM(Amount

if(TransactionType='SELL', SUM(Amount)* -1)

if(TransactionType='DIVIDEND', SUM(Amount)* -1)

Do you have any suggestions?