topic Re: Association in straight table in QlikView

Association in straight table

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

Hi All,

My data like

LOAD * Inline [

ID,NAME,TECHNOLOGY

100,A,Qlikview

200,B,Informatica

300,A,Qliksense

400,D,Java

500,D,Drupul

600,E,Qliksense

700,B,Oracle

];

like this i have 5000 rows of data i have .

here i need who are associated with multiple technologies.

Dim:-NAME,TECHNOLOGY

Exp:-Count(ID)

Exp O/P:-

NAME,TECHNOLOGY

A,Qlikview,

A,Qliksense,

D,Java,

D,Drupul,

B,Oracle,

B,Informatica,

Re: Association in straight table

qlikview979 — Fri, 01 Dec 2017 11:44:59 GMT

how can i write calculation dimension in dimension level for this

Re: Association in straight table

big_dreams — Fri, 01 Dec 2017 11:45:33 GMT

Hi,

take table box

add Name & Technology.

Regards,

Re: Association in straight table

big_dreams — Fri, 01 Dec 2017 11:46:15 GMT

What do you want to achieve.

can you explain in details??

Regards,

Re: Association in straight table

Mark_Little — Fri, 01 Dec 2017 11:49:00 GMT

Hi,

Your calculations should be something like

IF(Count(ID)>1,Name)

Mark

Re: Association in straight table

Anil_Babu_Samineni — Fri, 01 Dec 2017 11:52:18 GMT

May be this?

Count({<NAME = {"=Count(TOTAL <NAME> ID)>1"}>} TOTAL <NAME> ID)

Count({<NAME = {"=Count(TOTAL <NAME> ID)>1"}>} ID)

OR, This is dimension

=If(Aggr(Count({<NAME = {"=Count(TOTAL <NAME> ID)>1"}>} ID), NAME), NAME)

Re: Association in straight table

Anil_Babu_Samineni — Fri, 01 Dec 2017 11:52:37 GMT

Make sure, To use Suppress for that

Re: Association in straight table

avinashelite — Fri, 01 Dec 2017 11:53:47 GMT

try like this in the expression that should also work

if(count(ID)>1,Count(ID))

in the dimension

if(Aggr(Count(ID),NAME)>1,NAME)

Re: Association in straight table

qlikview979 — Fri, 01 Dec 2017 12:10:45 GMT

I tried all Conditions not working,

even

my condition is working in sample data =Aggr(if(count(NAME)>=2,NAME),NAME)

But not working in final table.

Re: Association in straight table

Anil_Babu_Samineni — Fri, 01 Dec 2017 12:13:15 GMT

What you mean by final table? Seems working

Re: Association in straight table

avinashelite — Fri, 01 Dec 2017 12:20:15 GMT

could you share the sample data file ..lets check

Re: Association in straight table

qlikview979 — Fri, 01 Dec 2017 12:23:20 GMT

Your condition is working fine in my sample data also,but in my dashboard when i use this condition its not getting correct result.

i don't know why its not working

Re: Association in straight table

qlikview979 — Fri, 01 Dec 2017 12:24:06 GMT

Due to security reasons i am not able to share data file.

Re: Association in straight table

avinashelite — Fri, 01 Dec 2017 12:33:46 GMT

Create mock up data for this and share with us

Re: Association in straight table

qlikview979 — Fri, 01 Dec 2017 12:50:05 GMT

Hi All,

I am sharing mock up data in pivot table , what ever i highlighted with yellow color,i want to remove that unique data from my table.

First sheet :- Mock up data

Second sheet :- Expected output

this expression i am using

=if(len(trim([Date Trained])) = 0, COUNT({<[Event Status]-={'DROPPED','HOLD','CANCEL'},

[Event Type]={'SPKRPGM'},[Site Participant Attendance Status]={'ACCEPTED','ATTENDED'}>}[Event ID]))

regards

Mahesh

Re: Association in straight table

qlikview979 — Mon, 04 Dec 2017 14:47:59 GMT

Hi All,

please check my attached file and help me on this.

Regards

Mahesh

Re: Association in straight table

qlikview979 — Mon, 04 Dec 2017 14:55:35 GMT

stalwar1‌kush141087‌loveisfail‌swuehl‌

Re: Association in straight table

vishsaggi — Mon, 04 Dec 2017 15:08:21 GMT

Few clarifications.

- Event Type, Date Trained, Site Participant Attendance Status where are these fields in your excel sheet.

- Your expected output show N, O, P, Q, R values fro Speaker Name, why M should not be considered any criteria for that?

- You have few expressions used where we cant see the field names used in those expression. Do we have to use these expressions too to recreated in Qlik or just use only fields without any expressions?

Re: Association in straight table

qlikview979 — Mon, 04 Dec 2017 15:27:24 GMT

Sorry bro,i am sharing new Mock up file

PFA

Re: Association in straight table

qlikview979 — Mon, 04 Dec 2017 15:37:36 GMT

can any one help me on this?