topic Re: Date variable in Set Analysis in QlikView

Date variable in Set Analysis

danielact — Tue, 24 May 2016 14:38:40 GMT

I have a text box which uses set analysis containing a date variable. The date is changed using a calendar object. It calculates correctly at first, but when I change the date, it doesn't update the result in the text box. If I do something (such as change to WebView and back, or go into the formula and add a space to it), it will update to the correct value. It appears it just isn't recalculating as it should.

Any idea if there's a way to fix this glitch? I really don't want to have to use an If statement for it.

Re: Date variable in Set Analysis

sunny_talwar — Tue, 24 May 2016 14:43:48 GMT

What is the expression you are using right now?

Re: Date variable in Set Analysis

danielact — Tue, 24 May 2016 14:46:22 GMT

=Count( {$<[Date Opened]={'=[Date Opened]>=vStartDate and [Date Opened]<=vEndDate'}>} Distinct CaseNumber)

Re: Date variable in Set Analysis

sunny_talwar — Tue, 24 May 2016 14:51:22 GMT

Difficult to comment unless we see it. Do you have a sample you can share?

Re: Date variable in Set Analysis

danielact — Tue, 24 May 2016 14:54:25 GMT

Sorry, but no, I can't share the file.

Re: Date variable in Set Analysis

sunny_talwar — Tue, 24 May 2016 15:01:07 GMT

Can you try this:

=Count( {$<[Date Opened]={"=[Date Opened]>=vStartDate and [Date Opened]<=vEndDate"}>} Distinct CaseNumber)

Re: Date variable in Set Analysis

MarcoWedel — Tue, 24 May 2016 20:48:05 GMT

Hi,

maybe helpful:

Dates in Set Analysis

regards

Marco