topic Re: Excluding two products and combining two markets in App Development

Excluding two products and combining two markets

niranjana — Thu, 17 Mar 2022 07:51:06 GMT

Hi,

I have a requirement where I have to show two markets: all products in first market and in second market all products except two.

In variable input, the variable is vBrandMarket. For showing products of one market , I have hardcoded as 'Brand_Market={"MS Market"}' in the input box expression which is working fine. That is , when I select this "MS Market" it is showing all products of that market in the straight table. Straight table dimension is "Brand_Product".

Now I have a requirement, where I have a market called "NS Range". On selecting this in input box, I must show all products of NS Range + all products of MS Market but excluding two products in MS Market (Gilenya,Mayzent).

I tried this but didnt work.

if(Brand_Market='NS Range',Brand_Product) and if(Brand_Market='Gilenya Market',if(not match(Brand_Product,'Gilenya','Mayzent'),Brand_Product))

Thanks in advance

Niranjana

Re: Excluding two products and combining two markets

Iswarya_ — Thu, 17 Mar 2022 10:09:24 GMT

Can you share some sample data.

Re: Excluding two products and combining two markets

niranjana — Thu, 17 Mar 2022 12:18:43 GMT

Hi I am attaching the screenshot as I cant share the data.

When I select NS Range, I need to see the products of NS Range + MS Market (excluding two products).

Is it possible to limit in dimension or variable input?

Re: Excluding two products and combining two markets

niranjana — Wed, 23 Mar 2022 13:19:47 GMT

HI I got the correct expression:

'Brand_Market={"NS Range","Gilenya Market"},Brand_Product-={"Gilenya","Mayzent"}'

Thanks