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

    Naresh M

      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