Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Valued Contributor

Date Range

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)

or

=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

5 Replies

Re: Date Range

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')

kunkumnaveen
Valued Contributor

Re: Date Range

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

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.

kunkumnaveen
Valued Contributor

Re: Date Range

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

Sure, try this:

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

or

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