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.

[#2]

thks for the help. 🙂

[chrismarlow]

I would invest time in looking at the set analysis stuff. It is more powerful and elegant than the If route (much as the If route does work ).