Get the value in expression

[vipin_mishra479]

here i have attached the application and excel file.

I have a Amount by customer

like

Customer , Amount

A ,111

B , 222

C , 333

and here i have create one inline table where i define Group and Stregity

like

Group,Stregity

111,New

222,Middle

333,Old

So final result i want is

Customer  Amount  Stregity

    A             111       New

    B              222      Middle

    C             333       Old

[antoniotiman]

Hi Vipin,

Try

Apply:
Mapping
LOAD * INLINE [
Amount, Stregity
111, New
222, Middle
333, Old
121, Avg
221, Check
332, Done
];

Table:
LOAD Customer,
Region,
Amount
FROM
[https://community.qlik.com/servlet/JiveServlet/download/1119878-244514/Example%20Test.xlsx]
(ooxml, embedded labels, table is Sheet1);

//Join (optional Yes = 1 Table,No = 2 Table)
LOAD Customer,
ApplyMap('Apply',Sum(Amount)) as Stregity
Resident Table
Group by Customer;

Regards,

Antonio

[Ricardo_Gerhard]

Dear Vipin,

   On this case, what you only need to do is rename the column "Group" to "Amount" like was mentioned.

   Qlik uses the column to link data.

[#4 · Accepted solution]

Hi Vipin,

Its a bit strange requirement. But I believe what you want to do is to use the values from two different data island and use it in a straight table.

I have attached one qvw file, please check if it suffice your requirement.

Regards,

Sakir

[vipin_mishra479]

thanks man thanks for your help i appreciate it

[vipin_mishra479]

Hey Sakir Every thing is correct but for 111 you showing Avg but actual is new please check

[#7]

Hi Vipin,

Just add Group in concat expression of vStretigy under variables, it will be sorted by Group.

vStretigy should look like this now: =(Concat({1} chr(39) &  Stregity & chr(39),',',Group))

Hope this helps.

Regards,

Sakir