Qlik Community

Qlik Sense App Development

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

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
maggihelga
New Contributor

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

Hello

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
maggihelga
New Contributor

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

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?