Qlik Community

Qlik Sense App Development

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

Not applicable

Aggr Line Chart help

Please help!
I am creating a cumulative line chart and I am having some issues,

The data is retrived from a QVD,  and the date in the QVD starts from 9,15,2015

The line chart is for current month, that's why there is only one line. I dont know why the line moves down on the 15th for current month.

Here is the chart:

Dimensions: Day - Year

Expression - aggr(Rangesum(above(TOTAL(SUM ({<Month = {$(=Month(Today()))} , MonthYear=, WeekDay=>} [TIPS Amount])), 0,rowno(TOTAL))), Year, Month, Day)

Please explain why the chart dips on the 15th.

Thanks!

1 Solution

Accepted Solutions
MVP
MVP

Re: Aggr Line Chart help

Does this look right?

Capture.PNG

Read about sortable Aggr function: The sortable Aggr function is finally here!

7 Replies

Re: Aggr Line Chart help

Hi,

Its not possible to understand this issue, unless you share the sample data with us.

If possible share the sample .qvf file which will show your problem.

Regards,

Kaushik Solanki

MVP
MVP

Re: Aggr Line Chart help

How about trying this:

Aggr(RangeSum(Above(TOTAL(SUM ({<Month = {$(=Month(Today()))} , MonthYear=, WeekDay=>} [TIPS Amount])), 0, RowNo(TOTAL))), (Year, (NUMERIC)), (Month, (NUMERIC)), (Day, (NUMERIC)))

Not applicable

Re: Aggr Line Chart help

Hi Kaushik, Here is the file. please let me know if can provide any clarity to it. THANKS!

Not applicable

Re: Aggr Line Chart help

Hi Sunil, could you else what the numeric value will be?

I am attaching a file to this.

THANKS!

Not applicable

Re: Aggr Line Chart help

Attaching the QVF and the QVD generator code to the original post.

MVP
MVP

Re: Aggr Line Chart help

Does this look right?

Capture.PNG

Read about sortable Aggr function: The sortable Aggr function is finally here!

Not applicable

Re: Aggr Line Chart help

YES!

Thank you so much! This really helps!

Community Browser