13 Replies Latest reply: Oct 29, 2015 10:28 AM by Louise Grauss-Spoormaker RSS

    Can I have 2 different number formats in 1 column in Qlik Sense

    Louise Grauss-Spoormaker

      Hi,

       

      I have this table:

       

      ItemCurrencyPrice
      AUSD250,00
      AUSD250,00
      BEUR180,00
      BEUR180,00
      CUSD100,00
      CUSD100,00
      DEUR80,00
      DEUR80,00
      DEUR80,00

       

      In Qlik Sense I want it to look like this:

       

      ItemPrice
      A$ 500,00
      B€ 360,00
      C$ 200,00
      D€ 240,00

       

      Is that possible?

      Now I have everything in $ or everything in €.

      I tried formula's like if( Currency = USD, Price in $, Price in €) but nothing is working.

      So I am wondering if it's possible at all.

      Else I will use a Pivot Table and split the column in USD and EUR.

      (I don't want to use a currency conversion table.)

       

       

      I also have a table like this:

       

      ItemMinus or PlusPrice
      AMinus10,50
      BPlus12,60
      CPlus18,00
      DMinus25,95
      EPlus60,05

       

      In Qlik Sense I want it to look like this:

       

      ItemPrice
      Totall54,20
      A- 10,50
      B12,60
      C18,00
      D-25,95
      E60,05

       

      So if the Item is a expense I want it to be calculated as a minus amount.

      And if it is a income I want it to be calculated as a plus amount.

      Is that possible?