topic Problem with Set Analysis and Date in QlikView

Problem with Set Analysis and Date

btrompetter — Wed, 20 Jan 2010 17:42:09 GMT

Hello,

I want to filter a formular with set analysis and set a selected day but I don't know why it didn't work.

Here is the formular:

count( DISTINCT {$<
$(vLFLFlag) = { $(=vTotalLFLFilter) },
Jahr = { $(vSelectedYear) },
DATUM = { $(vCurDate) }
>} AD_ID_COUNT)

If I set DATUM = { '05.01.2010' } it works, but this is the same as the variable.

Thanks for help.

Bastian

Wed, 20 Jan 2010 17:57:32 GMT

Hello,

Try this :

count( DISTINCT {$<
$(vLFLFlag) = { '$(=vTotalLFLFilter)' },
Jahr = { '$(=vSelectedYear)' },
DATUM = { '$(=vCurDate)' }
>} AD_ID_COUNT)

Philippe

btrompetter — Thu, 21 Jan 2010 09:06:40 GMT

Thanks for the Tip it works.