topic Re: Need Help in QlikView

Need Help

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

Hi Team,

I have straight table Like Below,

I am calculaing Exceptions field in straight table like: conact(Exceptions,',')

Indiactor	Type	Emp ID	Cycle	Sox	Exceptions
Y	App	1216	Cycle 1	Yes	EX1
N	App	1216	Cycle 1	Yes	EX2,EX3,EX4

Now i want like data below:

Indiactor	Type	Emp ID	Cyce	Sox	Exceptions
Y,N	App	1216	Cycle 1	Yes	EX1,EX2,EX3,EX4

Anil_Babu_Samineni — Fri, 04 Aug 2017 08:28:17 GMT

Will work, If you provide work file

gireesh1216 — Fri, 04 Aug 2017 08:35:59 GMT

Hi Anil,

Please take above data only.

All fields data are same except "Indicator" and "Exceptions" data.

effinty2112 — Fri, 04 Aug 2017 08:39:17 GMT

Hi Gireesh

In your straight table have Type, Emp ID, Cycle & Sox as dimensions.

Measures: concat(Indiactor,',') and concat(Exceptions,',').

You can drag the expression column for Indiactor to the left to get the order of columns you want.

Hope this helps

Andrew

Anil_Babu_Samineni — Fri, 04 Aug 2017 08:44:35 GMT

This?

tresB — Fri, 04 Aug 2017 08:44:57 GMT

This?

Nagaraju_KCS — Fri, 04 Aug 2017 09:01:56 GMT

Use concat function for both Dimension and Expression