topic Re: Get the value in expression in QlikView

Get the value in expression

vipin_mishra479 — Wed, 25 Nov 2020 16:16:04 GMT

here i have attached the application and excel file.

I have a Amount by customer

Customer , Amount

A ,111

B , 222

C , 333

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

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

Re: Get the value in expression

arulsettu — Thu, 08 Sep 2016 09:40:04 GMT

change inline table like this

LOAD * INLINE [

Amount, Stregity

111, New

222, Middel

333, Old

121, Avg

221, Check

332, Done

];

it will create relation between two tables

Re: Get the value in expression

vipin_mishra479 — Thu, 08 Sep 2016 09:41:35 GMT

No we don't link this inline with that table

Re: Get the value in expression

Anil_Babu_Samineni — Thu, 08 Sep 2016 09:43:19 GMT

Or Try This

Load * inline[

Customer , Amount

A ,111

B , 222

C , 333];

Second:

Load * inline[

Group,Stregity

111,New

222,Middle

333,Old];

Load Group as Amount, Stregity Resident Second; Drop Table Second;

And then use this table box

Hope helpful

Table1:

LOAD * INLINE [

Customer , Amount

A ,111

B , 222

C , 333

];

Table2:

LOAD *, Group as Amount INLINE [

Group, Stregity

111, New

222, Middel

333, Old

];

Re: Get the value in expression

arulsettu — Thu, 08 Sep 2016 09:43:35 GMT

then what is the use of inline table?

Re: Get the value in expression

vipin_mishra479 — Thu, 08 Sep 2016 09:47:31 GMT

this is just example so that i can writ this way in Actually some of multiple amount i will get this amount so there is no way to link this with inline

And inline is just i want to know what was the stragity for this amount.

Re: Get the value in expression

Anil_Babu_Samineni — Thu, 08 Sep 2016 09:50:55 GMT

Then share the real sample data, with expected o/p

Re: Get the value in expression

vipin_mishra479 — Thu, 08 Sep 2016 09:57:08 GMT

here i have attached the updated one

Re: Get the value in expression

vipin_mishra479 — Thu, 08 Sep 2016 09:57:26 GMT

Out put is same

Re: Get the value in expression

varshavig12 — Thu, 08 Sep 2016 10:00:13 GMT

Give alias name to "Group" as "Amount"

Re: Get the value in expression

kumarkp412 — Thu, 08 Sep 2016 10:01:08 GMT

Hi Arul,

Just try this.

You can make it just rename the Group name into Amount .Then if you are using default association it will take the Stregity values into ur first table.

Thanks

Kumar

Re: Get the value in expression

vipin_mishra479 — Thu, 08 Sep 2016 10:02:03 GMT

no its not possible above i have attached the new application

Re: Get the value in expression

arulsettu — Thu, 08 Sep 2016 10:02:20 GMT

Re: Get the value in expression

varshavig12 — Thu, 08 Sep 2016 10:03:56 GMT

eg: output :

west

New

Re: Get the value in expression

Chanty4u — Thu, 08 Sep 2016 10:04:19 GMT

try below script

t1:

LOAD * INLINE [

Customer, Amount

A, 111

B, 222

C, 333

];

LOAD *, Amount as Group

Resident t1;

LOAD * INLINE [

Group, Stregity

111, New

222, Middle

333, Old

];

Re: Get the value in expression

varshavig12 — Thu, 08 Sep 2016 10:05:36 GMT

Can you please update the output as per the new data ?

Re: Get the value in expression

susovan — Thu, 08 Sep 2016 10:39:58 GMT

Hi Vipin,

You can also try this process

Table1:

LOAD Customer,

Amount as Group

FROM

[Example Test.xlsx]

(ooxml, embedded labels, table is Sheet1);

Left Join

Table2:

LOAD * INLINE [

Group, Stregity

111, New

222, Middel

333, Old

121, Avg

221, Check

332, Done

];

Re: Get the value in expression

vipin_mishra479 — Thu, 08 Sep 2016 10:42:24 GMT

Please check my second attached file is t the posible that with out link this will be posible

Re: Get the value in expression

varshavig12 — Thu, 08 Sep 2016 10:46:40 GMT

Do you mean that you want to fetch data from different without using join (without link) ?

Re: Get the value in expression

vipin_mishra479 — Thu, 08 Sep 2016 10:48:37 GMT

yes i don't want to join i don't want to link but due to how i want this in my chart