Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

abc_18
Contributor

How to get values using mapping table

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.

1 Solution

Accepted Solutions

Re: How to get values using mapping table

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;

View solution in original post

7 Replies

Re: How to get values using mapping table

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;

View solution in original post

big_dreams
Contributor III

Re: How to get values using mapping table

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

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

big_dreams
Contributor III

Re: How to get values using mapping table

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

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

big_dreams
Contributor III

Re: How to get values using mapping table

true...

abc_18
Contributor

Re: How to get values using mapping table

Thank you very much sunny for your help.

logic is working perfectly.