Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Set analysis code error

Hi All,

I have attached a picture about my problem statement.

Hope I was able to pictorially explain whats going wrong.

Please help,

Regards,

Bikash

Tags (5)
1 Reply
erich_shiino
Honored Contributor

Set analysis code error

Hi, Bikash

Sometimes, set analysis does not handle the date format very well.

I suggest you use a auxiliary field for the DW date as an integer.

In the script, where you have something like:

Load

DW_LOAD_DATE,

... ETC

, include another line

load

DW_LOAD_DATE,

num(DW_LOAD_DATE) as nDW_DATE,

... etc

Your vConvStart and vConvEnd should get max and min of this new field

=min(nDW_DATE) and = max(nDW_DATE)

Your set analysis should also change to compare nDW_DATE instead of DW_LOAD_DATE

hope this helps,

Erich