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

Lost information when using IF statement

Hey everyone,

Well, I have some data with the following colums on my database:

TYPE, VALUE, YEAR, MONTH

I am trying to make a bar chart with only one TYPE type.

I am using Sum(if([TYPE]="A", [VALUE]))

It does sum up all VALUEs in TYPE A, but then I lose the Year and Month information on the grap. All the VALUE is displayed in the gray bar.

Can anyone help me out with this?

Sem título.png

0 Replies