1 Reply Latest reply: Sep 29, 2016 11:55 AM by Shraddha Gajare RSS

    How to do Currency conversion on QlikSense based on selected Currency filter

      Hi EveryOne,

       

      How to do Currency conversion on QlikSense based on selected Currency in Filter area

       

      I have a Examples like below

      Sales;

      Date, Item, Currency, Amount

      2016-09-09, A, RUPIAH, 3000

      2016-09-09, A, USD, 120

      2016-09-09,  A, INR, 2000

      2016-08-14, B, EUR, 100

      2016-08-14,  B, INR, 2100

      2016-08-14, B, USD, 50

       

      And

       

      My currency conversion information is extracting from Excel file.

       

       

      Based on the above data, If i select USD it has to convert all data into USD dolllars, and if i select EUR it has to appear in EUR's and If i Select INR all values should be shown in INR. This Currency filter i am going to provide in filter area.

       

      If anyone has done this scenario already in QlikSense kindly please help me.

       

      Thanks and regards,

      Naresh.M