Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Comparison Graph

Hi Guys

I am struggling to create a comparison graph - I want to create a graph whereby I can select 2 or 3 different months and compare daily performance.

If someone knows how please assist. I have also attached the type of graph I would like to achieve.

Tags (1)
10 Replies
MVP
MVP

Re: Comparison Graph

Would you be able to provide a sample with detailed expected output to help you better

Not applicable

Re: Comparison Graph

Thanks Sunny T for a quick response

I have data from july 2015 to date. This data shows the money that was paid by customers to our account.

I want to create a cumulative line graph with "day" as dimension and for the "measure" I want to use (the sum of money paid per month on that day), I do not want the graph to add all the months at once but i want to add a filter pane that contains all the months so that when I select 2 different months I can be able to compare how we are tracking e.g. compared to last month.

If I select 2 different months I want to see 2 lines on a line, one line showing the first month I have selected and the other line showing the second month I have selected. Please check the attachment in my earlier post

kidbank3
Contributor III

Re: Comparison Graph

You could simply create a two dimension line chart.  The dimensions will need to be day then month, and it will need to be a single expression2016-06-17 07_47_06-Qlik Sense Desktop.jpg

Not applicable

Re: Comparison Graph

Thank Michael - This looks exactly like what i want to do but I am still learning this. Please give me an example on how the expression should read or how I can actually do it so that i can also document it for future.

lalitkgehlot89
New Contributor III

Re: Comparison Graph

Hi,

Check the attached file

Not applicable

Re: Comparison Graph

Ooops the file is blank when I open it, can you type the logic for me?

kidbank3
Contributor III

Re: Comparison Graph

Joe,

I can't share a QVF file because my app has private data, but here is the step by step:

     1. Assuming you've loaded your app with your day/month data, drag a line chart object onto your sheet.

     2. On the right hand chart menu go to the data section and add two dimensions, day first, then month.

     3. Then further down the menu you'll see the measures input.  Add your measure expression, something like sum(), count().

     4. Lastly, add a filter pane object onto you sheet (back on the left side menu under charts) and add month as the dimension

Not applicable

Re: Comparison Graph

Thanks Michael -this  helps but the problem comes in when the below expression is made void which helps to calculate cumulative per month because thats what I want the graph to show

$(accum)Sum(Gross_Amount_Rands)$(/accum)

kidbank3
Contributor III

Re: Comparison Graph

Joe,

I think it's complicated to get exactly what you want, but here's something you can try:

    Set your dimension as day of month

    Set your expression as rangesum( above( Sum(Gross_Amount_Rands),0,rowno()))/Sum(Total Gross_Amount_Rands)

    Then filter on you desired month

 

This won't show all the months together so it's not exactly what you need.  Just suggesting as an easy alternative

Community Browser