conditional if else?

[#1]

I am new to Qlikview and I hope somebody can help me...

i wanted to create a bar chart with dimension called Region ( East, West, North South )

and each region in the bar chart will display the total amount of money ( Net Order Value ) which was late in payment for more than 7 days (Invoiced_Days)

Dimension -> Region

Expression --> If(Invoiced_Days > 7,Sum([Net Order Value]),0)

but my dashboard indicate no data to display

pls assist. thanks

Remy.

[vinieme12 · Accepted solution]

Try this

Sum({<Invoiced_Days = {">7"}>}[Net Order Value])

You might like reading

Set Analysis: syntaxes, examples

[chrismarlow]

Have you tried popping the If inside the sum;

Sum(If(Invoiced_Days > 7,[Net Order Value],0))

[Anonymous]

you first need to define net order value and then sum..so use this expression

=sum(if(Invoiced_Days > 7,[Net Order Value]))

[vinieme12]

why would you not prefer using Set Analysis?

[#6]

thank you for your assistance. it worked 🙂

[#7]

i am still new to qlikview and trying to look at the various ways of doing this 🙂

and it seem like set analysis are the way to go. I really appreciate the assistance rendered.

thanks

[#8]

thank you for your assistance. this worked too 🙂

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post).

If not, please make clear what part of this topic you still need help with .

[vinieme12]

Glad to help ☺

Cheers

V