topic Re: How to get values using mapping table in QlikView

How to get values using mapping table

abc_18 — Fri, 13 Apr 2018 05:51:02 GMT

Hi,

In my dashboard report, I need to show the drop down where user should be able to select:

1.> Massorder &

2.> All orders(should include 'Massorder' + 'Other orders')

I have created a mapping table for that and it's connected to fact table like below

[MAP_IsMassorder]:

Mapping LOAD

skey_line,

'Massorder' as [%order_type]

FROM [order.qvd](qvd);

Fact:

applymap('MAP_IsMassorder',skey_line,'All orders') as %Ordertype

But in drop down, when I select 'All orders' it's not including Massorder values, only Other orders are appearing.

Re: How to get values using mapping table

sunny_talwar — Fri, 13 Apr 2018 11:37:01 GMT

I would try like this

LinkTable:

LOAD skey_line,

'Massorder' as [%order_type]

FROM [order.qvd](qvd);

Concatenate (LinkTable)

LOAD skey_line,

'All orders' as [%order_type]

FROM Fact;

Fact:

LOAD *

FROM Fact;

Re: How to get values using mapping table

big_dreams — Fri, 13 Apr 2018 11:49:07 GMT

How we will get to know if order is mass order or other order .

required sample data to understand it.

Sunny logic work but here, there massorder and AllOrders are same, So I think we required where condition to flag it properly.

Regards,

Re: How to get values using mapping table

sunny_talwar — Fri, 13 Apr 2018 11:55:38 GMT

That is not true if AllOrders and MassOrders are coming from two different qvd files...

Re: How to get values using mapping table

big_dreams — Fri, 13 Apr 2018 11:59:58 GMT

Sorry my bad. I did not notice that you used different qvd name,

but it is not mention in original question.

Regards,

max

Re: How to get values using mapping table

sunny_talwar — Fri, 13 Apr 2018 12:02:04 GMT

That's right, but since there is no point of mapping from same qvd to the same qvd... I think there might be one qvd used for mapping and the other one for fact

Re: How to get values using mapping table

big_dreams — Fri, 13 Apr 2018 12:07:24 GMT

true...

Re: How to get values using mapping table

abc_18 — Tue, 17 Apr 2018 05:01:24 GMT

Thank you very much sunny for your help.

logic is working perfectly.