topic Re: RE:Issue with Selection Criteria?? in QlikView

RE:Issue with Selection Criteria??

priyav24 — Thu, 22 Aug 2013 11:31:51 GMT

Hello Everybody,

I have an issue with the selections,There is an calendar object in which the user needs to select the fromdate and todate which is working fine.But issue is when the user selects an account name ,the Previous selections is getting deselected..

Thanks in Advance ,

Priya

Re: RE:Issue with Selection Criteria??

Siva_Sankar — Thu, 22 Aug 2013 11:34:30 GMT

couldnt able to open your attached file.

Re: RE:Issue with Selection Criteria??

Gysbert_Wassenaar — Thu, 22 Aug 2013 11:37:31 GMT

If a new selection contradicts with existing selections then the existing selections are cleared. So if the account name doesn't have any data for the fromdate and todate then those two fields are cleared.

Re: Re: RE:Issue with Selection Criteria??

priyav24 — Thu, 22 Aug 2013 11:46:21 GMT

Thanks @Gysbert,

so what can be done if i dont want show the account name in the straight table which is not in range of date..

Re: RE:Issue with Selection Criteria??

Gysbert_Wassenaar — Thu, 22 Aug 2013 12:27:52 GMT

Perhaps changing the OpeningBalance expression to something like this works:

=if(sum(VoucherAmount),

num(Sum({$<GlDate={"<$(=Date(FromDate,'DD/MM/YYYY'))"}>} VoucherAmount+OpeningAmount), 'BD #,##0;(BD #,##0)')

)

Re: RE:Issue with Selection Criteria??

Thu, 22 Aug 2013 12:36:31 GMT

Hi Priya,

The reason behind that is the data of account name is not having the those selection

Regards,

Santhosh G

Re: RE:Issue with Selection Criteria??

priyav24 — Thu, 22 Aug 2013 12:38:01 GMT

Thanks @Gysbert,

Could you Please Explain How it works

Re: RE:Issue with Selection Criteria??

Gysbert_Wassenaar — Thu, 22 Aug 2013 13:18:19 GMT

It first checks if there the sum of VoucherAmount is not zero. Perhaps count({<VoucherAmount={'*'}>} VoucherAmount) would be better since there could be transactions that when summed up have zero as result. The idea is first to make sure that there are transactions for that account in the selected period before calculating the opening balance. That's needed because that calculation overrides the GlDate selections.