topic Re: conditional if else? in QlikView

conditional if else?

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: conditional if else?

vinieme12 — Tue, 26 Jul 2016 19:01:24 GMT

Try this

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

Re: conditional if else?

chrismarlow — Tue, 26 Jul 2016 19:01:40 GMT

Have you tried popping the If inside the sum;

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

Re: conditional if else?

Anonymous — Tue, 26 Jul 2016 19:07:54 GMT

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

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

Re: conditional if else?

vinieme12 — Tue, 26 Jul 2016 19:11:37 GMT

why would you not prefer using Set Analysis?

Re: conditional if else?

Tue, 26 Jul 2016 23:24:28 GMT

thank you for your assistance. it worked 🙂

Re: conditional if else?

Tue, 26 Jul 2016 23:26:23 GMT

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

Re: conditional if else?

Tue, 26 Jul 2016 23:28:00 GMT

thank you for your assistance. this worked too 🙂

Re: conditional if else?

oknotsen — Wed, 27 Jul 2016 07:13:54 GMT

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 .

Re: conditional if else?

vinieme12 — Wed, 27 Jul 2016 07:30:25 GMT

Glad to help ☺

Cheers

Re: conditional if else?

Wed, 27 Jul 2016 13:49:16 GMT

thks for the help. 🙂

Re: conditional if else?

chrismarlow — Thu, 28 Jul 2016 16:13:22 GMT

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 ).