topic Re: Set Analysis in QlikView

Set Analysis

Anonymous — Sat, 07 Nov 2015 16:00:31 GMT

What could be wrong with the following expression:

=Num((Sum({< [Date Dispensed] = {'>=$(=Date('2013-09-01'))<=$(=Date('2014-08-31'))', [New Product Indicator]={'YES'} >} [MedAid Amount] + [Shortfall])), '$##,##0.00')

Regards

Re: Set Analysis

swuehl — Sat, 07 Nov 2015 16:07:25 GMT

You are missing a curly bracket } and probably the sequence of single quotes will not be parsed correctly by QV.

Use a combination of double and single quotes instead.

=Num((Sum({< [Date Dispensed] = {">=$(=Date('2013-09-01'))<=$(=Date('2014-08-31'))"}, [New Product Indicator]={'YES'} >} [MedAid Amount] + [Shortfall])), '$##,##0.00')

Then take care that the default date format matches the format of [Date Dispensed] and that your default number separators are matching your num() format code. If in doubt, specify the Date() format code and the num() separators explicitely.

Re: Set Analysis

maxgro — Sat, 07 Nov 2015 16:15:26 GMT

=Num(

(Sum({<[Date Dispensed]={">=$(=Date('2013-09-01'))<=$(=Date('2014-08-31'))"}, [New Product Indicator]={YES}>}

[MedAid Amount] + [Shortfall])), '$##,##0.00')

Re: Set Analysis

Anonymous — Sat, 07 Nov 2015 16:46:17 GMT

Thank you will check

Re: Set Analysis

Anonymous — Sat, 07 Nov 2015 16:56:54 GMT

Thank you will advise accordingly