6 Replies Latest reply: Mar 24, 2016 9:47 AM by Cyrille Thybert RSS

    Qlik sense calculation - Set analysis ?

    Cyrille Thybert

      Hi all,

       

      I have a need on qliksense : doing simulation.

      Let me explain :

       

      I have one contract with different version (one per month), in this contrat my exchange rate and sales have variations. And this contrat is based on 2 countries.

       

      What I need to do is simulating the exchange rate on all contract version based on one of version.

       

      One example :

      I want to apply the exchange rate coming from the version 1 for USA and UK on corresponding sales :

       

      This is my set of data :

       

      data_sample 1.png

       

      I keep the rate from version 1 and I apply it on all sales.

       

      data_sample 2.png

       

      and I aggregate all togather :

       

       

      This is the result I need with the exchange rate of Version 1:

      data_sample 3.png

       

       

      In qliksense I'm trying to do that with set analysis but it doesn't works well because the value doesn't split correctly through Versions usgin this : ({$<"Contrat Version"={'Version 4'}>}"xrate euro") .. I don't know how to calculate it with differents level of aggregation.

       

      Any idea to resolve that ?

       

      you will find attached a dashboard sample with this set of data and the data set

       

       

      Thank you.