Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
bobby_chowdary
New Contributor III

mapping Pivot column Test to another table column Test

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

1 Solution

Accepted Solutions
MVP
MVP

Re: mapping Pivot column Test to another table column Test

I assumed some formats for your indicater column and ended up with

COUNTRY MovieColletionMovieprofitShowsCountColumn combinationlength of Combination columnPick( Match( Column(1)&Column(2)&Column(3), '566','066','060','560',' 6 ','56 '), '566','066','060','560',' 6 ','56 ' )Pick( Match( Column(1)&Column(2)&Column(3), '566','066','060','560',' 6 ','56 '), '2','3','4','5','1','6' )Pick( Match( Column(1)&Column(2)&Column(3), '566','066','060','560',' 6 ','56 '), 'superhit','average','hit','above avg','nostatus','status is pending' )
Ind56656635662superhit
japan 66 663
php 6 6 3 6 1nostatus
uk56656635662superhit
us56 56 356 6status is pending
Total 5 6 6 566 3 566 2 superhit

There is no indicater value for ' 66', hence no mapping.

View solution in original post

15 Replies
MVP
MVP

Re: mapping Pivot column Test to another table column Test

Have you tried what we've discussed in

Combining povit columns and comparing  data in povit

?

edit:

seems my suggestion still works..

bobby_chowdary
New Contributor III

Re: mapping Pivot column Test to another table column Test

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

MVP
MVP

Re: mapping Pivot column Test to another table column Test

Have you looked into my sample qvw?

It seems to work for me.

bobby_chowdary
New Contributor III

Re: mapping Pivot column Test to another table column Test

yeah i tired now as well,

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

Capture.PNG

MVP
MVP

Re: mapping Pivot column Test to another table column Test

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

COUNTRY MovieColletionMovieprofitShowsCountColumn combinationPick( 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' )
Ind5665665662superhit
japan0660660663average
php0600600604hit
uk5665665662superhit
us5605605605above 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.

bobby_chowdary
New Contributor III

Re: mapping Pivot column Test to another table column Test

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

Capture.PNG

MVP
MVP

Re: mapping Pivot column Test to another table column Test

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).

bobby_chowdary
New Contributor III

Re: mapping Pivot column Test to another table column Test

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.

MVP
MVP

Re: mapping Pivot column Test to another table column Test

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 '?