mapping Pivot column Test to another table column Test

[Anonymous]

Hi team,

i am trying to find solution for below requirement since last two months but till now i didn"t get any idea

Here we go

i have one pivot  ..in that using  Linest_m function i was created some values or Text  base upon requirement ..more details please check in Pivot  in attached QVW file

after linest_m results i want to map that results to another table "indicater" field ...after mapping the fields .if both vales are mapped correctly then i need to display the  another table "Value,text" field  details in Pivot table

but here  when i was  mapping to another table column to the pivot column result ..it showing error i tired so many ideas but no use to me 

note:

"Povit column" means combination of Linest_m function results

please suggest me best way of finding this  issue solution

Regards,

Bob

[swuehl]

Have you tried what we've discussed in

Combining povit columns and comparing  data in povit

?

edit:

seems my suggestion still works..

[Anonymous]

yeah i rember it is also similar but that functionality is not working here ...i tired lot of times with my ideas and your ideas as well ..but no use

[swuehl]

Have you looked into my sample qvw?

It seems to work for me.

[Anonymous]

yeah i tired now as well,

you can see the below screen shot as well it wont work for me ..sorry

[swuehl]

That's not the sample I've uploaded neither the expression I've suggested.

COUNTRY	MovieColletion	Movieprofit	ShowsCount	Column combination	Pick( Match( Column(1)&Column(2)&Column(3), 060,066,560,566), '060','066','560','566' )	=Pick( Match(Column(1)&Column(2)&Column(3), 060,066,560,566), '4','3','5','2' )	Pick( Match( Column(1)&Column(2)&Column(3), 060,066,560,566), 'hit','average','above avg','superhit' )
Ind	5	6	6	566	566	2	superhit
japan	0	6	6	066	066	3	average
php	0	6	0	060	060	4	hit
uk	5	6	6	566	566	2	superhit
us	5	6	0	560	560	5	above avg
Total	5	6	6	566	566	2	superhit

Note that I've used Dollar Sign Expansions in the Pick/Match to create the expressions dynamically from your tables.

[Anonymous]

hay it"s working fine in our sample files but when i implemented in my main dashboard it"s not working .

i am not able to find reason do you have any idea?

please see my below screen shot

[swuehl]

That's hard to tell from your screen shot.

I can't even tell from your screenshot if the numbers you want to map even exist in Match() argument list.

Your numbers you want to compare seem to be formatted differently, there is an additional space in some values.

If you need to compare text values, you might need to add single quotes around the values in the Match() function arguments (adjusting the dollar signe expansion's concat function).

[Anonymous]

yeah you are saying correct in attached dashboard please i am using text

please see my attached QVW file now.

Please don"t convert to integers or numbers i want to map text to text

please make your suggested changes and reply with QVW file

Regards,

Brahma.

[swuehl]

I believe you need to clarify how your calculated column combination should be mapped to the indicater column.

You calculated combination shows three chars, either one being '5','6' or a space ' '.

You want to map these three char literals to indicater:

resultshow:

Load * inline [

indicater,value,text

566,2,superhit

066,3,average

060,4,hit

560,5,above avg

6 ,1,nostatus

56 ,6,status is pending

];

Qlik by default trims the values, so could you tell if the second last line should actually be ' 6 '?