topic Re: Issue in set analysis in QlikView

Issue in set analysis

Mon, 06 Jul 2015 21:41:34 GMT

Hi,

Can someone please tell me what's wrong with the date.

({$<[Transaction Invoice Date] = {'>=$( =(05/01/15))'},

[Payoff Transaction Code]={'0001', '0002', '0003', '0004'},[Transaction Counter]={'*1*'},[PCRO]={'*1-1-60*'}>}

[Transaction Invoice Total Amount Billed] * FABS([SEC Funder Multiplier]))

I just want to exclude all amounts pertaining to transactions before 05/01/15. Just unable to put it in the set analysis expression. I only have problem with the date part, rest works fine.

Regards,

Sachin

Re: Issue in set analysis

sinanozdemir — Tue, 07 Jul 2015 01:11:22 GMT

Try the below since you want to exclude all dates before 05/01/2015:

({$<[Transaction Invoice Date] = {">='05/01/2015'"}

Re: Issue in set analysis

settu_periasamy — Tue, 07 Jul 2015 02:06:17 GMT

Hi,

if you have the date format like 05/01/15, try like this

({$<[Transaction Invoice Date] = {'>=05/01/15'}

if the Transaction Invoice Date is different, you need to convert using the date function.

Date('05/01/15','MM/DD/YYYY')

Re: Issue in set analysis

jagan — Tue, 07 Jul 2015 03:11:29 GMT

Hi,

Try like this

({$<[Transaction Invoice Date] = {">=$('05/01/15')"},

({$<[Transaction Invoice Date] = {">=$(=Date('05/01/15'))"},

Regards,

Jagan.