topic Re: If condition in set analysis in QlikView

If condition in set analysis

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

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

‌

Re: If condition in set analysis

robert_mika — Fri, 01 Apr 2016 13:09:48 GMT

Could you post sample of your data or application?

Re: If condition in set analysis

mario-sarkis — Fri, 01 Apr 2016 13:13:10 GMT

‌unfortunatly i cant if u need any explaination i can explain more

Re: If condition in set analysis

t_chetirbok — Fri, 01 Apr 2016 13:23:46 GMT

you said that you have main table with 3 fields, what does it mean first and second table?

how your data model look like?

Re: If condition in set analysis

t_chetirbok — Fri, 01 Apr 2016 13:25:40 GMT

so, you need to calculate count of rows with title "RM" and count of rows with title "ABM Retail"

that's right?

Re: If condition in set analysis

mario-sarkis — Fri, 01 Apr 2016 13:32:00 GMT

‌yes the main table has date , name and title

and two others , the first one containt points and the second [Br Point]

if i select on name with title RM calculate sum of point and if i select on ABM need to calculate the sum of Br point

Re: If condition in set analysis

t_chetirbok — Fri, 01 Apr 2016 13:35:42 GMT

Your table doesn't have relation each other?

maybe something like this:

if(getfieldselections(Title)='RM',sum(Point),

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

Re: If condition in set analysis

mario-sarkis — Fri, 01 Apr 2016 13:50:49 GMT

‌thank you for ur reply but the problem the will not work when i select the name

Re: If condition in set analysis

t_chetirbok — Fri, 01 Apr 2016 14:01:48 GMT

can you explain once again what exactly are you doing and what should be display in report.

What objects do you want to use?

How your main table relates with other?

Re: If condition in set analysis

mario-sarkis — Fri, 01 Apr 2016 14:05:15 GMT

‌yes of caurse it will be a text box

my requirment is when i select the name if the title field is RM sum(points) and the title is ABM sum(Br points)

Re: If condition in set analysis

t_chetirbok — Fri, 01 Apr 2016 14:11:09 GMT

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

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

Re: If condition in set analysis

t_chetirbok — Wed, 06 Apr 2016 06:37:41 GMT

Qlik Community Tip: Marking Replies as Correct or Helpful