topic Re: Can we concatinate String value table with integer value table in QlikView

Can we concatinate String value table with integer value table

Tue, 12 Aug 2014 13:17:56 GMT

Hi Qv,

can we concatinate below two tables ,one table have sum of integer values another table value have string.

table1:

Dim1	PRIOR WEEK Data	PRIOR MONTH DATA
101	25	35
102	50	68
103	12	26
104	35	45

table2:

Dim2	PRIOR WEEK Data	PRIOR MONTH DATA
TIMELINE	WK17	WK13-WK17

output look like this.

DIM1	PRIOR WEEK DATA	PRIORMONTH DATA
TIMELINE	WK17	WK13-WK17
101	25	35
102	50	68
103	12	26

Thanks

Re: Can we concatinate String value table with integer value table

Anonymous — Tue, 12 Aug 2014 13:19:28 GMT

Yes you can, give it a go !!

Re: Can we concatinate String value table with integer value table

Tue, 12 Aug 2014 13:40:11 GMT

Thax bill,

Can you pls elobarate more with example qvw I am unable to get the output like above

I have used Dimestion as Dim1 and expressions like sum(PRIORWEEKDATA),sum(PRIOR MONTHDATA) but unable successed .

Re: Can we concatinate String value table with integer value table

swapnil_kumbhar — Tue, 12 Aug 2014 13:43:46 GMT

Yes you can.

PFA

Re: Can we concatinate String value table with integer value table

Tue, 12 Aug 2014 13:49:14 GMT

Hi,

TABLE1:

LOAD *

FROM table1.xlsx;

CONCATENATE (TABLE1)

LOAD *

FROM table2.xlsx;

Regards,
Marius

Re: Can we concatinate String value table with integer value table

manideep78 — Tue, 12 Aug 2014 13:56:26 GMT

Hi SwathiRaj P

Try this:

Table1:

LOAD * INLINE [

Dim1, Week, Month

101, 25, 35

102, 50, 68

103, 12, 26

104, 35, 45

];

Table2:

Concatenate

LOAD Dim2 as Dim1,*;

LOAD * INLINE [

Dim2, Week, Month

Timeline, WK17, WK13-WK17

];

Drop Field Dim2;

It should work.

Hope this helps you.

Regards,

Manideep

Re: Can we concatinate String value table with integer value table

Tue, 12 Aug 2014 14:03:31 GMT

It should be fine in table box,.....can we get same output in straight table by using expressions like sum(PRIORWEEKDATA),sum(PRIOR MONTHDATA) .

Thanks

Re: Can we concatinate String value table with integer value table

Tue, 12 Aug 2014 14:08:34 GMT

can we get same output in straight table instead of table box.

Re: Can we concatinate String value table with integer value table

Tue, 12 Aug 2014 14:16:48 GMT

ya, just concatenate in script

Re: Can we concatinate String value table with integer value table

manideep78 — Tue, 12 Aug 2014 14:17:28 GMT

PFA

Re: Re: Can we concatinate String value table with integer value table

Tue, 12 Aug 2014 14:21:00 GMT

I did not successed in straight i have attached same here.

Thanks

Re: Re: Can we concatinate String value table with integer value table

rwunderlich — Tue, 12 Aug 2014 14:22:51 GMT

sum() will turn your strings into zeros. So you'll need to conditionally test for the string in the expression like:

=if(NOT IsNum(maxstring(Month)), maxstring(Month), sum(Month))

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Can we concatinate String value table with integer value table

Anonymous — Tue, 12 Aug 2014 14:25:15 GMT

Use the only function instead of the sum function in your Straight Table

Re: Re: Re: Can we concatinate String value table with integer value table

rwunderlich — Tue, 12 Aug 2014 14:27:17 GMT

See attached using

=if(NOT IsNum(maxstring(Week)), maxstring(Week), sum(Week))

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Can we concatinate String value table with integer value table

martynlloyd — Tue, 12 Aug 2014 14:34:09 GMT

Hi, you may encounter problems sorting your text to the top of the table - for this you could use Dual Values:

...

Dual('TIMELINE', 0) as DIM1,

// or

Dual(DIM2,0) as DIM1

...

You will then be able to sort numerically.

Regards,

Marty.

Re: Re: Can we concatinate String value table with integer value table

Tue, 12 Aug 2014 14:53:22 GMT

Thanku so much rob....can we make it as bold letters for Time Line row alone in that table,I tried to used the Custom format cell option but it should be applicable for whole table but i need only Time Line row.

Time Line WK17 WK13_WK17
?

thank you

Re: Re: Re: Can we concatinate String value table with integer value table

rwunderlich — Tue, 12 Aug 2014 15:12:57 GMT

For each Dimension and Expression, press the + sign to access the attributes and use this expression for the "Text Format":

if(IsText(maxstring(Week)),'<B>')

-Rob