topic Re: expression is null in QlikView https://community.qlik.com/t5/QlikView/expression-is-null/m-p/1052260#M939159 <HTML><HEAD></HEAD><BODY><P>In general. you should use aggregation functions, try maybe something like</P><P></P><P>=Sum( If( len(trim(price1)), price1, price2))</P></BODY></HTML> Thu, 04 Feb 2016 16:18:48 GMT swuehl 2016-02-04T16:18:48Z expression is null https://community.qlik.com/t5/QlikView/expression-is-null/m-p/1052258#M939157 <HTML><HEAD></HEAD><BODY><P>Is there a way to do a same expression like this in pivot table</P><P></P><P></P><P>Case when price1 is null then price 2 </P></BODY></HTML> Thu, 04 Feb 2016 16:17:07 GMT https://community.qlik.com/t5/QlikView/expression-is-null/m-p/1052258#M939157 Anonymous 2016-02-04T16:17:07Z Re: expression is null https://community.qlik.com/t5/QlikView/expression-is-null/m-p/1052259#M939158 <HTML><HEAD></HEAD><BODY><P>SUM(If(isNull(price1),price2,price1))</P></BODY></HTML> Thu, 04 Feb 2016 16:18:03 GMT https://community.qlik.com/t5/QlikView/expression-is-null/m-p/1052259#M939158 MK_QSL 2016-02-04T16:18:03Z Re: expression is null https://community.qlik.com/t5/QlikView/expression-is-null/m-p/1052260#M939159 <HTML><HEAD></HEAD><BODY><P>In general. you should use aggregation functions, try maybe something like</P><P></P><P>=Sum( If( len(trim(price1)), price1, price2))</P></BODY></HTML> Thu, 04 Feb 2016 16:18:48 GMT https://community.qlik.com/t5/QlikView/expression-is-null/m-p/1052260#M939159 swuehl 2016-02-04T16:18:48Z