topic set analysis not working, in QlikView

set analysis not working,

Mon, 30 Apr 2012 09:39:08 GMT

I have an expression for set analysis,

numericcount({< DISCHARGE_DATE = {'>=$(=Date(Start_dt))<=$(=Date(End_dt))'} >} DISCHARGE_DATE) which is not working if the data is retrieved from oracle,

the same expression i implemented with the data extracted from sql server, I cant understand whats the difference in here. Any help would be appreciated. Do i need to change something or make any settings.

set analysis not working,

jagannalla — Mon, 30 Apr 2012 09:52:45 GMT

How are you loading data? I mean please load your data according qlikview syntax ( i.e. Preceding load). It helps you even if you change your DB.

For example:

Load A, B;

Select A,B from DB.Table1;

Hope it helps you.

set analysis not working,

Mon, 30 Apr 2012 12:20:49 GMT

Still i could not make it work, did all the possibilities. Any other idea.

Re: set analysis not working,

jagannalla — Mon, 30 Apr 2012 12:26:53 GMT

Can you check in which format the dates are there for the fields DISCHARGE_DATE, Start_dt , End_dt. If they are not in same format, make them to look in same format in chart or load script itself.

For eg:

Date(DISCHARGE_DATE,'DD/MM/YYYY')

Date(Start_dt,'DD/MM/YYYY')

Date(End_dt,'DD/MM/YYYY')

Still your problem is not able to resolve. Please attach two sample files one with sql data one with oracle data.