Qlik Community

Qlik Sense App Development

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

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Contributor

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
Contributor

Re: How to use min function along with applymap

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;
Highlighted

Re: How to use min function along with applymap

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.