topic Re: Set E in QlikView

Set E

krishnacbe — Wed, 10 Oct 2012 04:52:03 GMT

I new in implemneting Set Expression. Below is my set expression in a straight table.

count({<ExceptionsTeamIntervention={'-1'},Status={1},
Code={'no_suitable_appointment','contractor_not_found','appointment_not_found',
'manual_deployment_required'}>} if(IsNull(CompletionDate)=-1, LastUpdatedDate-ClaimDate

))

If I select Completiondate then the record is not displayed in Straight table. But should not display that record even if I am not selection CompletionDate.

Thanks in Advance.

Regards

Krishna S

Re: Set E

SunilChauhan — Wed, 10 Oct 2012 06:39:54 GMT

use below code

count({<ExceptionsTeamIntervention=,Status={1},
Code={'no_suitable_appointment','contractor_not_found','appointment_not_found',
'manual_deployment_required'} ,CompletionDate-={}>}, LastUpdatedDate-ClaimDate

)

hope this helps

Re: Set E

Wed, 10 Oct 2012 06:41:34 GMT

Hi,

Based on what you've said, you need to display the record even if you are not selecting Completion Date. Am I correct?

Regards,

Janzen

Re: Set E

krishnacbe — Wed, 10 Oct 2012 06:43:03 GMT

Hi Janzen

Yes, you are right.

Regards

Krishna S

Re: Set E

Wed, 10 Oct 2012 06:54:58 GMT

Hi,

May I ask what is the purpose of displaying a list box of Completion Date if it must not affect your straight table. If thats the case, you can use alternate state so that whenever you select a value in listbox, it will not affect the values in the straight table.

Regards,

Janzen