topic Re: Date Range in QlikView

Date Range

kunkumnaveen — Thu, 21 Jul 2016 10:44:47 GMT

i had created two variables in variable overview

vMaxdate =Date(Date#('3 Jan' & Year(Date), 'DD MMMyyyy'), 'D MMM')

vMindate = =Date(Max({Group2}Date),'D MMM')

expression :i tried two exp

=sum({<Date={">=$(vMindate)<=$(vMaxdate)"},bid={1},set = {P}, Type={1}>} value)

=sum({Group2<Date={">=$(vMindate)<=$(vMaxdate)"},bid={1},set = {P}, Type={1}>} value)

if i select 16 Jan from Date field from calendar object whose Alternative State is Group2

then i can clear can see the below thing is happen

sum({<Date={">=3 Jan<=16 Jan"},bid={1},set = {P}, Type={1}>} value)

which means my variables are carrying correct date values .

but unfortunately i am getting ZERO as output ,which shouldn't be ...

so my concert is this a data flow problem ?. I mean is my Date in text format if so how can i make it in to numeric

suppose data values are like

Date

1 Jan

2 Jan

10 Jan

11 Jan

20 Jan

plz any help/.......

thanks

naveen

Re: Date Range

sunny_talwar — Thu, 21 Jul 2016 10:49:01 GMT

You are right, your date could be text. Why don't you do this kind of transformation in the script for Date field as well?

Date(Date#('3 Jan' & Year(Today()), 'DD MMMyyyy'), 'D MMM')

or just this:

Date(Date#('3 Jan', 'D MMM'), 'D MMM')

Re: Date Range

kunkumnaveen — Thu, 21 Jul 2016 10:54:08 GMT

HI,

I got about 14 tabs and i have not clue from where the Date filed is coming ,but i am sure there are multiple Date fields in script because i can see a key type of icon over Date field ,so what i mean, is there any alternative way to convert Date field in to numeric at frond end

Re: Date Range

sunny_talwar — Thu, 21 Jul 2016 10:56:38 GMT

AFAIK, you are not able to convert from text to numeric on the frontend. You can try giving a shot within the document properties -> Number Tab, but I doubt it will work.

Re: Date Range

kunkumnaveen — Thu, 21 Jul 2016 11:53:48 GMT

i think i found something .can u plz tell me how can i write a vMindate exp with group in it same as vMaxdate

vMindate=Date(Date#('3 Sep' & Year(Date), 'DD MMMyyyy'), 'D MMM')(where to fit group in this exp)

vMaxdate=Date(Max({Group2}Date),'D MMM')

Re: Date Range

sunny_talwar — Thu, 21 Jul 2016 12:05:04 GMT

Sure, try this:

vMindate = Date(Date#('3 Sep' & Year(Only({Group2}Date)), 'DD MMMyyyy'), 'D MMM')

vMindate = Date(Date#('3 Sep' & Year(Max({Group2}Date)), 'DD MMMyyyy'), 'D MMM')