topic Re: use original field in QlikView

use original field

everest226 — Mon, 14 May 2018 18:53:02 GMT

HI ,

Bellow is the sample , i am trying to create two separate chart , is it possible to use field from table that has been drop , in one chart and field from resident table in another chart .

so basically i want to use field Cat in one chart and Zone in another chart. this is just a logic or any work around

Re: use original field

sunny_talwar — Mon, 14 May 2018 18:57:21 GMT

Cat and Zone are one of the same thing... but Cat is dropped... how would you use Cat as a dimension when it isn't even present in the your application? What exactly are you trying to do?

Re: use original field

everest226 — Mon, 14 May 2018 19:06:20 GMT

AB:

Load

[Channel Code],

Counter,

[ Agency Code],

[Agent Name],

[Payment],

from <<<<<<<

[Final AB]:

Load

[Channel Code],

Counter,

[ Agency Code],

[Agent Name],

[Payment] - Previous([ Payment]) as orginal _Payment,

Resident Group

Order by [ Number],QVDYear,QVDWeek,[Tr Booking Date];

Drop Table Group;

So basically one chart that are built are using all the calculated group by field from residence table . the requirement is to build another chart but without all the group by calculation . basically from original AB table . hope i am clear

Re: use original field

sunny_talwar — Mon, 14 May 2018 19:10:10 GMT

I don't see any group by? I see Order by... but what are you grouping here or intending to group here?

Re: use original field

everest226 — Mon, 14 May 2018 19:10:55 GMT

I mean order by

Re: use original field

sunny_talwar — Mon, 14 May 2018 19:12:24 GMT

So you want to have payment and original_payment?, then why do you not bring payment in the final table?

AB:

Load

[Channel Code],

Counter,

[ Agency Code],

[Agent Name],

[Payment],

from <<<<<<<

[Final AB]:

Load

[Channel Code],

Counter,

[ Agency Code],

[Agent Name],

[Payment],

[Payment] - Previous([ Payment]) as orginal _Payment,

Resident Group

Order by [ Number],QVDYear,QVDWeek,[Tr Booking Date];

Drop Table Group;

Re: use original field

everest226 — Mon, 14 May 2018 19:13:03 GMT

So its order by QVD week and Year, , and i have use those field on chart , what if i dont want to use order by data and only want to use original table data in new chart in same application

Re: use original field

everest226 — Mon, 14 May 2018 19:14:21 GMT

ok i understand now

Re: use original field

sunny_talwar — Mon, 14 May 2018 19:14:30 GMT

But order by is doing nothing to your original data... you can still use it without any issues

Re: use original field

everest226 — Mon, 14 May 2018 19:18:37 GMT

Thanks For your help