topic Re: numbers are not coming in the charts in 12.4 version of desktop in QlikView

numbers are coming in the charts in 12.4 version of desktop

sonysree88 — Sat, 16 Nov 2024 19:23:35 GMT

Hi All,

Kindly help me on the below issue.

Please find the attached script file and the images.

In the 12.2 ,we are getting the numbers as per the calc, Same application am opening in 12.4 nothing is visible and even if i can take that expression in the text box that also didn't work for us.

Re: numbers are coming in the charts in 12.4 version of desktop

Anil_Babu_Samineni — Thu, 26 Dec 2019 09:29:19 GMT

Please share the expression?

Re: numbers are not coming in the charts in 12.4 version of desktop

sonysree88 — Thu, 26 Dec 2019 10:01:44 GMT

This is the expression which we are using it

= num($(vESABalanceDay1)+$(vCashAtBankDay1), '$ #,##0;($ #,##0)')& if(Display='$', '', Display)

$(vCashAtBankDay1)=

(sum({<ALCOFormatLvl1 = {'Total Assets'}, DimEnteredGLCurrencyCode={'AUD'}, DimEnteredGLCurrencyDesc=, ALCOFormatLvl2 = {'3rd Party Liquid Assets'}, GLEntityCode={'001'}, PeriodIndicator={'C'}, Level6GLAccountCode={'ACASHB'}, dBusinessDate={'>=$(#=vCompareDate1)<=$(#=vCompareDate1)'} >} GLREC_GLSpotBalanceAUD))
/ DivNumber

(vESABalanceDay1) =

((
sum({1<PeriodIndicator={'C'}, ALCOLevel5Post={'ESA'}, DimEnteredGLCurrencyCode={'AUD'}, GLEntityCode={'001','055'}, dBusinessDate={'>=$(#=vCompareDate1)<=$(#=vCompareDate1)'} >} DEP_BalanceSheetAmountAUD)
+sum({1<PeriodIndicator={'C'}, ALCOLevel5Post={'ESA'}, DimEnteredGLCurrencyCode={'AUD'}, GLEntityCode={'001','055'}, dBusinessDate={'>=$(#=vCompareDate1)<=$(#=vCompareDate1)'} >} LOA_BalanceSheetAmountAUD)
+sum({1<PeriodIndicator={'C'}, ALCOLevel5Post={'ESA'}, DimEnteredGLCurrencyCode={'AUD'}, GLEntityCode={'001','055'}, dBusinessDate={'>=$(#=vCompareDate1)<=$(#=vCompareDate1)'} >} SEC_FaceValueAUD)
+sum({1<PeriodIndicator={'C'}, ALCOLevel5Post={'ESA'}, DimEnteredGLCurrencyCode={'AUD'}, GLEntityCode={'001','055'}, dBusinessDate={'>=$(#=vCompareDate1)<=$(#=vCompareDate1)'} >} MAN_FaceValueAUD)
))
/ DivNumber

Re: Numbers are not coming in the charts in 12.4 version of desktop

sonysree88 — Fri, 03 Jan 2020 05:10:21 GMT

Numbers are not coming in the charts in 12.4 version of desktop

Please let know why the issue persisting after desktop and server upgrade. I tried to recreate the chart that also not working. If I open the same QVW file in 12.1 SR7 that its working fine.

PFB for 12.1 version numbers are coming fine.