topic Re: how to load different same values in column in QlikView

how to load different same values in column

vikasmahajan — Mon, 24 Aug 2015 11:21:20 GMT

Dear all

I have following script

Load * INLINE [

Commentory,id

AAAA,1

BBBB,3

CCCC,5

DDDD,4

EEEE,6

AAAA,20

BBBB,30

CCCC,50

DDDD,40

EEEE,60

];

I want to display 'AAAA','BBBB','CCCC','DDDD','AAAA','BBBB','CCCC','EEEE' with combination of id .

Thanks

Vikas

Re: how to load different same values in column

Mon, 24 Aug 2015 11:27:29 GMT

Temp:

Load * INLINE [

Commentory,id

AAAA,1

BBBB,3

CCCC,5

DDDD,4

EEEE,6

AAAA,20

BBBB,30

CCCC,50

DDDD,40

EEEE,60

];

Final:

Commentory&''&id as Combo

Resident Temp;

Re: how to load different same values in column

Digvijay_Singh — Mon, 24 Aug 2015 11:27:34 GMT

Use Concat(id,';') as expression and Commentory as Dimension in straight table

Re: how to load different same values in column

marcus_malinow — Mon, 24 Aug 2015 11:28:28 GMT

Vikas,

you could try using the dual() command.

LOAD dual(Commentary, id) as Commentaryid, *

tc..etc..

Marcus

Re: how to load different same values in column

pokassov — Mon, 24 Aug 2015 11:29:02 GMT

Hi!

You can hide column id in chart to achieve your goal

Re: how to load different same values in column

Anonymous — Mon, 24 Aug 2015 12:59:07 GMT

Hi Vikas,

Do you want commentary and id columns as one column or all values in commentary and id columns in same row?

Re: how to load different same values in column

vikasmahajan — Mon, 24 Aug 2015 13:27:44 GMT

resolved with declaring variable =Concat(Commentory , '|')

and use = ValueList( '$(v1)') to display

Thanks all for your reply

Vikas

Re: how to load different same values in column

pokassov — Mon, 24 Aug 2015 13:44:36 GMT

Hi!

Can you attach working example?