topic Re: duplicate values in QlikView

duplicate values

Wed, 26 Nov 2014 08:44:32 GMT

Com_Key	LDAP Group
FRM ANALYTICS_rramirez	MCCO FRM OPS
FRM ANALYTICS_rramirez	MCCO BFRM
FRM ANALYTICS_rramirez	MCCO AREAMGR IFRM

i have two cols as mentioned above if i click com_key then any one of the LDAP Group should show,

below is my existing script

Meta_Con:

LOAD

[Dashboard App]&'_'&[Unix ID] as Com_Key,

upper([LDAP Group]) as [LDAP Group],

[Unix ID] as [Unix_ID]

Re: duplicate values

rubenmarin — Wed, 26 Nov 2014 08:55:18 GMT

Hi karthikeyan,

QV only stores different values, so internally it has that Com_Key "FRM ANALYTICS_rramirez" is associated to LDAP Group "MCCO FRM OPS", "MCCO BFRM" and "MCCO AREAMGR IFRM".

So when you click Com_Key, all LDAP Groups associated are filtered. If you have list boxes with Com_Key and LDAP Group you can check the behaviour.

Re: duplicate values

Wed, 26 Nov 2014 08:58:35 GMT

hi ruben

is it not possible to show any one value in ldap group

Re: duplicate values

rubenmarin — Wed, 26 Nov 2014 09:04:48 GMT

Values aren't shown in a list box? List Box will show all values stored in [LDAP Group] by default, even if they are not related to any other field.

If you try to show [LDAP Group] in a text box or graph expression you can use Concat() funtion to show all values:

Concat([LDAP Group])

Re: duplicate values

Wed, 26 Nov 2014 09:08:37 GMT

yes i want to show this in a st.table

if i click com_key only one ldap group should show is it possible

Re: duplicate values

rubenmarin — Wed, 26 Nov 2014 09:11:08 GMT

You can use minstring() or maxstring() functions to get the first or last group alphabetically:

MinString([LDAP Group])

Re: duplicate values

jagan — Wed, 26 Nov 2014 09:30:31 GMT

Hi,

Try MaxString() or MinString()

Straight Table:

Dimension: Com_Key

Expression: MinString([LDAP Group]) OR MaxString([LDAP Group])

OR If you want to handle this in script try below script

Meta_Con:

LOAD

[Dashboard App]&'_'&[Unix ID] as Com_Key,

upper([LDAP Group]) as [LDAP Group],

[Unix ID] as [Unix_ID]

FROM DataSource;

MaxGroup:

LOAD

Com_Key,

MaxString([LDAP Group]) AS MaxLDAPGroup

RESIDENT Meta_Con

Group By Com_Key;

Now use this column wherever you need.

Hope this helps you.

Regards,

Jagan.

Re: duplicate values

Wed, 26 Nov 2014 11:00:33 GMT

thank you sir...