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
"Povit column" means combination of Linest_m function results
please suggest me best way of finding this issue solution
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' )|
|us||5||6||56||3||56||6||status is pending|
There is no indicater value for ' 66', hence no mapping.
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
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' )|
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
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:
Load * inline [
56 ,6,status is pending
Qlik by default trims the values, so could you tell if the second last line should actually be ' 6 '?