Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Forecasting and Filters

Hello, everyone.

Im making a simple month forecast table. It fills the days yet to come with an average of the days with actual data.

If i dont make any filtering it works just fine. But if i filter, for example, payments with money or credit cards the forecast data wont be displayed.

If i put the filter in se analysis it works fine too. But i dont want to add all payments types in set analysis. Because i also want to sue this expression in a line graph.

Can anyone tell me why this is happening?

Thanks in advance!

1 Solution

Accepted Solutions

Re: Forecasting and Filters

May be try this:

If(Sum({1}TOTAL) <> 0, Sum(TOTAL), Avg({<TOTAL = {'>0'} TOTAL Aggr(Sum(TOTAL), DIA)))

4 Replies

Re: Forecasting and Filters

May be try this:

If(Sum({1}TOTAL) <> 0, Sum(TOTAL), Avg({<TOTAL = {'>0'} TOTAL Aggr(Sum(TOTAL), DIA)))

Not applicable

Re: Forecasting and Filters

I tried it, but it fills all rows with the average.

Re: Forecasting and Filters

All the rows? Really? Can you show me a sample where it does?

Not applicable

Re: Forecasting and Filters

Oops, you were right. Thanks!

I got confused because it lost the capability to filter by month and year and i was looking at 2015 august.

Its working, thank you very much and sorry for the confusion! Altough it still doesnt work for pivot tables.

But now i can at least make it work for line charts!