Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Expression in chart question

Hi everyone,

I'm wondering if a specific bit of logic is achievabe by using expressions. I have fields that represent a date(which is monthly), current balance, and days past due - for each date there are several current balances. For each date I would like to capture the sum of all current balances just on that date that fall within a specific range of days past due, then divide that by the sum of all current balances on that specific date (reguardless of amount of days past due). This will result in a percentage of current balance dollars that fall within a specific date range. I want to graph this in a static way so that if I select a specific date range the graph will not change, and instead just zoom in. Does anyone know if this is possible?

Thank you.

1 Reply
Not applicable

Re: Expression in chart question


Could you provide a sketch of the desired chart and sample data for example in excel file?



Community Browser