Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

I'm having trouble displaying my report.

Hello,

My Receivables on Year 2009 is 1,098,301,231.64 and my Receivable per quarter is 274,575307.91, every time i make a chart it always display my Quarterly Receivable.

Can you help me to display the 1,098,301,231.64 Receivable on the chart?

Please Help me on my project.

Year Receivable.png

Quarter Receivable.png

Untitled2.png

Here is my some photo attached

2 Replies
MVP
MVP

Re: I'm having trouble displaying my report.

Well, that's hard to answer with the information provided (i.e. lacking information about the data model, chart dimensions, expressions etc.).

Please double check that you don't have any selections in field Quarter when  you are creating a chart with dimension Year, since the selections will affect the data aggregated in every chart (this is QV default behaviour).

You can clear selections in expression evaluation using set analysis, maybe this is the case in other charts you are looking at.

Anyway, without knowing more details about your settings, I think it's just wild guessing.

Not applicable

Re: I'm having trouble displaying my report.

sir I just forgot to add the Aggr() function. I already get the correct answer.
btw Thanks for sharing your idea

Community Browser