topic Re: Before / After calculations in QlikView

Before / After calculations

tmumaw — Sat, 16 Nov 2024 02:05:38 GMT

Good morning everyone. I'm having a little problem using the before and after functions in a calculation and could use a little help.

I have a dimension called office:

1320 Denver in 2019 they had 569 customers, then in 2018 they had 854, then in 2017 they had 1,025. I thought I could use the following to determine the increase or decrease in customer counts from the previous year. For some reason it's not giving me what I expected to see. Any help? Thanks

Count({<YTDFlag = {1}>} DISTINCT [Ship To]) - After(Count ({<YTDFlag = {1}>} DISTINCT [Ship To]))

Re: Before / After calculations

rubenmarin — Tue, 29 Oct 2019 16:05:22 GMT

Hi, Before and After can work in pivot tables with vertical dimensions (columns).

For rows you can try with Below instead of After

Re: Before / After calculations

tmumaw — Tue, 29 Oct 2019 16:19:44 GMT

I know that. What I have is a pivot table with years across and sales offices down.

1370 Denver 2019 / 500 (+250) 2918 / 250 (-100) 2017 / 350 (+200) 2016 / 150 (-150) 2015 / 300

I'm trying to get then numbers in (*)

Re: Before / After calculations

rubenmarin — Tue, 29 Oct 2019 16:25:07 GMT

Then it should work, chek atachment. Maybe the set analysis is restricting data?

Try setting to different expressions to check if they return the expected values, like in Test table

Re: Before / After calculations

tmumaw — Tue, 29 Oct 2019 16:31:13 GMT

Thanks. It was the set analysis. Which is very strange (you would think it would work).