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: 
Not applicable

Help needed: a bar in my chart is unexpectedly not showing up

Hi there,

Can someone have a look at the attached testproject?

  • I have a pivot table with 4 expressions, and in the pivot table it is showing me the values that I expect. So far so good!
  • when I do a "Fast type change" to a bar or linechart... one of the expressions (named Loan - (remainder) ) is not showing up (it is only showing up for 1 year and not for the 15 others)
  • Attached I have the sample project. I made a clone of my pivot table so my problem is visible in 1 eye-catch... but also you  could do the fast type change inthe privot table to see the behavior

Can anybody explain why this field is not showing up in the bar/line chart while it DOES have values in the pivot table?

Any help is highly appreciated! (and of course some solution or workaround to get it working in my chart as well)

Thanks!

Roberto

5 Replies
sivarajs
Specialist II
Specialist II

Hi,

Before function returns null value for all chart types except pivot table

Refer help option

Sivaraj S

Not applicable
Author

Ah, you're right; i didn't notice that.

Do you have a suggestion for a function that I can use for my purpose?

My calculation for this column is based on outcomes of the previous year (previous record)...

I hope there are possibilities!

sivarajs
Specialist II
Specialist II

What you are tryin to do with first expression(Loan - (remainder))

some of the fields are not there

kji
Employee
Employee

Try using "above" instead of "before".

Clever_Anjos
Employee
Employee

Maybe you could use a Set Analysis expression thar returns previous year