topic Re: how to write if else condition in QlikView

how to write if else condition

kunkumnaveen — Thu, 20 Jul 2017 12:38:04 GMT

Hello All,

I am merging both expression by using or function is that correct ,what it mean is either one scenario is right then show spend,but I thinking the way I am merging is not correct ,because I am getting -1 as output of all the materials

Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},New_Column={"=New_Column<>p_Material"}>}SPEND) or

Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},New_Column={"=New_Column=p_Material"} ,p_Material={"=count(distinct Ip_ID)=1"}>}SPEND)

Re: how to write if else condition

jmvilaplanap — Thu, 20 Jul 2017 12:38:36 GMT

Hi,

Why you don't merge both expressions in one single set analysis?

Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},New_Column={"=New_Column<>p_Material"}> <SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},New_Column={"=New_Column=p_Material"} ,p_Material={"=count(distinct Ip_ID)=1"}>}SPEND

I think this will work

Re: how to write if else condition

jmvilaplanap — Thu, 20 Jul 2017 12:42:37 GMT

Sorry, is with a "+"

Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},New_Column={"=New_Column<>p_Material"}> + <SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},New_Column={"=New_Column=p_Material"} ,p_Material={"=count(distinct Ip_ID)=1"}>}SPEND)

Re: how to write if else condition

kunkumnaveen — Fri, 21 Jul 2017 04:41:07 GMT

thanks for your reply,one doubt

will + work same as or function,because i need either one expression is true then show spend

Re: how to write if else condition

Anil_Babu_Samineni — Fri, 21 Jul 2017 04:45:14 GMT

Yes and i would ask you to read related stuff which "Set Analysis Operators in Qlikview"

Re: how to write if else condition

jmvilaplanap — Fri, 21 Jul 2017 08:11:14 GMT

Hi,

This + work as an OR operator