Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
krishna4bo
Contributor

Transformations

Hi All,

If column Assigned Group = end with ’- aaa’  then display  in column Assigned Support Organization ‘Applications – aaa’ instead of A.

Ex: Raw data

Assigned Support Organization

Assigned Group

A

Apps Mosaic - Finance - aaa

A

Apps Mosaic - Finance - aaa

B

Apps Mosaic Project Warranty Finance - aaa

B

Apps Mosaic Project Warranty Finance - aaa

B

Apps Mosaic Project Warranty Finance - aaa

A

Apps Mosaic - Finance - aaa

C

PMO

Required format :

Assigned Support Organization

Assigned Group

Applications – aaa

Apps Mosaic - Finance - aaa

Applications – aaa

Apps Mosaic - Finance - aaa

B

Apps Mosaic Project Warranty Finance - aaa

B

Apps Mosaic Project Warranty Finance - aaa

B

Apps Mosaic Project Warranty Finance - aaa

Applications – aaa

Apps Mosaic - Finance - aaa

C

PMO

Thanks,

Krishna

Tags (1)
5 Replies
Highlighted
MVP
MVP

Re: Transformations

Try like:

If( WildMatch([Assigned Group], '*aaa') and  [Assigned Support Organization]= 'A', 'Applications – aaa' , [Assigned Group] )

Update: Added one more condition

Highlighted
antoniotiman
Honored Contributor III

Re: Transformations

May Be this

LOAD [Incident ID],
Status,
[Status Reason],
[Submit Date],
[Age of Incident (days)],
Company,
[SLM Status],
If([Assigned Support Organization]='A' and Trim(SubField([Assigned Group],'-',-1))='aaa','Application-aaa',
[Assigned Support Organization]) as [Assigned Support Organization],
[Assigned Group],
[Last Modified Date],
Priority
FROM
https://community.qlik.com/servlet/JiveServlet/download/1366610-300659/sampledata.xlsx
(ooxml, embedded labels, table is Sheet1);

Highlighted
vinieme12
Esteemed Contributor II

Re: Transformations

i think


if([Assinged Support Organization] = 'A' and  WildMatch([Assigned Group], '*aaa') , 'Applications – aaa' , [Assinged Support Organization] )

Highlighted
shanky1907
Contributor II

Re: Transformations

Please Take Calculated Dimension in place of your Dimension of 'Assigned Support Organization' and you can use the below code in its definition:

If([Assinged Support Organization] = 'A' and  WildMatch([Assigned Group], '*aaa') , [Assigned Group], [Assinged Support Organization] )

Highlighted
shanky1907
Contributor II

Re: Transformations

And use the name of this Calculated Dimension as: Assinged Support Organization