topic Re: set analysis in QlikView

set analysis

alexpanjhc — Mon, 12 Nov 2012 20:15:52 GMT

Hi I am struggling something maybe very easy for you folks

sum({$<Date = {$(=date(AddMonths(Date,-1),'MMM-YYYY'))}>} iCount)

date(AddMonths(Date,-1),'MMM-YYYY')) has values . but it showed me zero.

Where is the problem??

Re: set analysis

Mon, 12 Nov 2012 20:47:27 GMT

I think your problem may be that the field Date (see in bold)

date(AddMonths(Date,-1),'MMM-YYYY')) has values . but it showed me zero.

It is only possible to calculate with this field, when Qlikview recognizes this field as a date/numeric field.

You can check this in the table-viewer (Ctrl + T) and then hover over your Date-field and check if it has the tags date/numeric or timestamp. If for example the displayed tag there is "text" then you know that this is the issue.

What to do then?

Use Date#() function in your loadscript to parse your date from text to date

I'd like to hear the outcome!

Re: set analysis

alexpanjhc — Mon, 12 Nov 2012 20:55:38 GMT

Thank you for your respond.

I hover over on Date in the table viewer and the tag say $timestamp, $date. and i then still used Date#() to format the date, and I still get zeros.

Re: set analysis

Tue, 13 Nov 2012 00:27:38 GMT

Hi alexpanjhc!

Could you upload your application file? With partial data load, let's say 100 raws.

I believe it helps us to understand it faster.