If condition in set analysis

[mario-sarkis]

hey all ,

i have a main talbe that contain "date Name and Title" as

Date

first field   Name

second field   Title

is related to two table

i need to calculate the sum of points if TITLE: RM (from the first table) and the sum of [Br Points] if TITLE:ABM Retail (from the second table) and if no selection show the sum of two

hope you can help

REgards

‌

[t_chetirbok]

if(Concat(DISTINCT Title)='RM',sum(Point),

     if(Concat(DISTINCT Title)='ABM',sum([Br Point])))

[t_chetirbok]

Qlik Community Tip: Marking Replies as Correct or Helpful