Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
abc_18
Creator II
Creator II

How to use min function along with applymap

Hi,

I am trying to use min() function along with applymap, but I am getting invaild expression error beacuse of the use min function.

Below is my expression:-

[market_tmp]:
LOAD
ABC_Key ,
DEF_Key
FROM [$(vQVDLib)map_standard.qvd] (qvd);


[market]:
Mapping Load ABC_Key
,ApplyMap('MAP_skey_market',min([DEF_Key]),Null()) as skey_market
Resident [market_tmp];

drop table [market_tmp];

 

Can someone please sugegst, where am I making mistake?

2 Replies
santhiqlik
Creator
Creator

Hi,

You need to use Group by in your mapping load.
market:
Mapping Load ABC_Key
,ApplyMap('MAP_skey_market',min([DEF_Key]),Null()) as skey_market
Resident [market_tmp] group by ABC_Key;
sunny_talwar

You are using ApplyMap in your mapping table? You have another mapping table called MAP_skey_market?... not that this is wrong, but just want to make sure you are aware of this and are doing it right.