5 Replies Latest reply: Sep 4, 2017 6:38 AM by Anil Babu Samineni RSS

    Getselectedcount function in  qliksense

    Rakesh Pareek

      Hi,

       

      I am using below mentioned expression in qlikview and qliksense both, but when I am using in qlikview then its working properly, but when using same in qliksense then showing Error (Calculation time out).

       

      Expression is:

      if(GetSelectedCount(Date_Currency)=1,

      if(Flag_SHCP='1',Sum({<LinkDate={'<=$(vDate)'},Flag={'Balance_Sheet'}>}KSL),

      Sum({<LinkDate={'<=$(vDate)'},Flag={'Balance_Sheet'}>}TSL2*Rate_Currency1*Rate_CurrencyINR))

      ,

      if(Flag_SHCP='1',Sum({<LinkDate={'<=$(vToday)'},Flag={'Balance_Sheet'}>}KSL),

      Sum({<LinkDate={'<=$(vToday)'},Flag={'Balance_Sheet'}>}TSL2*Rate_Today*Rate_INR_Today))

      )

       

      My requirement is when I select Date_Currency, then it shows data for  selected date and also multiply with currencies of selected date (are in data iland) but by default is should calculate data as on today and should be multiply with today's date.