Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lucas4bi
Partner - Creator
Partner - Creator

Weird Before() Function Behaviour

Hello everyone,

i'm experiencing some weird results using Before() function on a pivot tablepivot_example.png

as you cas see from the picture above i use before() to get the previous value from column(3), which is the "Total Sales 2014" expression. On Australia i expect to get a null on april and june and get 216 on december, instead it gives me back the exact same number in the current column.

Another weird result is on the the India line: i see numbers like 7.972 and 1.572, but these numbers never appear on the India line, where does he get those from?

The only lines where it appears to work as expected are the lines where i have a value for the first month, as for France (you can't really see january from the picture but France is the only one with a value in january).

I've also tried different combinations with TOTAL <"Micro Area","Client Name">, but i never get the expected result.

Can anybody help me with this?

I am surely missing something

Thank you in advance,

Luca

0 Replies