Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
raadwiptec
Contributor II

map

Iam trying to apply the following applymap condition

AmountMapping

Mapping Load

Year([Date])& Month([Date])&[Currency]

amount

from Amount.txt

ApplyMap('AmountMapping', Year([Date])& Month([Date])&[Currency],'1') AS [Amount],

But i need the condition like this.

If Currency - 'USD' then it should be '40'  always irspective of years else it should take the currency amount from the Amount.txt file-

The second condition is the year should be 2017..

1 Reply
MVP
MVP

Re: map

if(Currency = 'USD',

     40,

     ApplyMap('AmountMapping', Year([Date])& Month([Date])&[Currency],'1')

     )

AS [Amount],

Community Browser