Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I assumed some formats for your indicater column and ended up with
COUNTRY | MovieColletion | Movieprofit | ShowsCount | Column combination | length of Combination column | Pick( 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' ) |
---|---|---|---|---|---|---|---|---|
Ind | 5 | 6 | 6 | 566 | 3 | 566 | 2 | superhit |
japan | 6 | 6 | 66 | 3 | ||||
php | 6 | 6 | 3 | 6 | 1 | nostatus | ||
uk | 5 | 6 | 6 | 566 | 3 | 566 | 2 | superhit |
us | 5 | 6 | 56 | 3 | 56 | 6 | status is pending | |
Total | 5 | 6 | 6 | 566 | 3 | 566 | 2 | superhit |
There is no indicater value for ' 66', hence no mapping.
Have you tried what we've discussed in
Combining povit columns and comparing data in povit
?
edit:
seems my suggestion still works..
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
Have you looked into my sample qvw?
It seems to work for me.
yeah i tired now as well,
you can see the below screen shot as well it wont work for me ..sorry
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.
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
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).
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.
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 '?