topic Re: if then else statement systax in QlikView

if then else statement systax

JACKNIEKERK — Wed, 25 Nov 2020 16:16:04 GMT

need to display in grid based on one the 2 valid

if (Pieces <> 0 , Pricetotal/Pieces) else (Grams <> 1 then Pricetotal/Grams)

Field names are ok formule gives error, so what do I wrong in syntax ?

Taoufiq_Zarra — Sat, 06 Jun 2020 11:30:28 GMT

May be

=if(Pieces <>0,Pricetotal/Pieces,if(Grams <>1,Pricetotal/Grams))

JACKNIEKERK — Sat, 06 Jun 2020 12:19:00 GMT

Ok what I realize is that grams goes first allways, due sometimes in table it tells how many items in the total weight

this runs ok if(Grams <> 0, sum(Pricetotal/Grams))

But in case NO grams only pieces , how do i that behind ,

in VB I could work with something like

if(Grams <> 0, sum(Pricetotal/Grams)) else sum(Pricetotal/Pieces))

Taoufiq_Zarra — Sat, 06 Jun 2020 12:27:45 GMT

also

if(Grams <> 0, sum(Pricetotal/Grams)),sum(Pricetotal/Pieces))

if not can you share a sample data and the expected output ?

JACKNIEKERK — Sat, 06 Jun 2020 19:49:27 GMT

Hello , its simple i think ,

Grams is first choice, due to it could happen field Grams contains value And Pieces contains value
if Grams =0 then Pieces are counting

I my visual programs i have this
just do not know , and trying to find the syntax in Qlikview

If Grams <> 0 Then
Sum = Pricetotal / Grams
Else
Sum = Pricetotal / Pieces
End If

JACKNIEKERK — Sat, 06 Jun 2020 20:49:56 GMT

Hello it works ok

just learned that i must be carefull with capitals , will not generate error, just will give nothing

This Grams should be grams then it works

thanks for helping out

if(Grams <> 0, sum(Pricetotal/Grams)),sum(Pricetotal/Pieces))

Saravanan_Desingh — Sat, 06 Jun 2020 21:57:11 GMT

You can also add Null check to this, if you want.

if(Grams <> 0 And Not IsNull(Grams), sum(Pricetotal/Grams)),sum(Pricetotal/Pieces))

JACKNIEKERK — Sun, 14 Jun 2020 10:21:53 GMT

thanks for tip