topic Re: Function as a modifier in QlikView

Function as a modifier

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

Hi guys,

I am trying to evaluate this function:

concat({<Order_Channel_Name={"=sum({1<[Transaction_Date.autoCalendar.Year]={"$(vLY)"}, [Transaction_Date.autoCalendar.Month]={"$(vMonth)"}>}Value-Tax)>0"}>}distinct Order_Channel_Name, ',')

I want a list separated with commas of Order Channels that have sales in Last year and same month as selected above 0

I have split the concat and sum functions and they work. It is just when I put them together that they don't.

Any ideas?

Thanks
George

Re: Function as a modifier

sunny_talwar — Tue, 20 Feb 2018 17:42:54 GMT

May be because of double quotes within double quotes? May be try one of these...

using Escape sequences

Concat({<Order_Channel_Name={"=sum({1<[Transaction_Date.autoCalendar.Year]={""$(vLY)""}, [Transaction_Date.autoCalendar.Month]={""$(vMonth)""}>}Value-Tax)>0"}>}distinct Order_Channel_Name, ',')

Or using single quotes instead of double quotes

Concat({<Order_Channel_Name={"=sum({1<[Transaction_Date.autoCalendar.Year]={'$(vLY)'}, [Transaction_Date.autoCalendar.Month]={'$(vMonth)'}>}Value-Tax)>0"}>}distinct Order_Channel_Name, ',')

Re: Function as a modifier

Anonymous — Tue, 20 Feb 2018 17:47:56 GMT

It works!! Thanks a lot!!