Date Format

[dunnalahk]

Hi,

I have one QVD in that i have one Month Field.

so when i try to filter in where condition by giving as below it's not returning me any Rows

Load * from XXX.qvd

where Month >='201801'

is it some problem with month field format ? can some help me.

Best Regards

HK

[dunnalahk]

Hi,

I have attached to Original post.

Best Regards,

HK

[dunnalahk]

HI Sunny,

I have attached the QVW to original post.

I am thinking its format issue.

Best Regards,

[elopez7811]

hello, I made a separation of bases forming qvd in 3 phases before reaching the final model.

1. consolidated; it accumulates my base as it normally arrives
2. transformation; the most important where our facility for dates is scheduled

date(Floor(CREATIONDATE),'DD/MM/YYYY') as CREATIONDATE,

     Day(CREATIONDATE) as CREATIONDAY, 

     Month(CREATIONDATE) as CREATIONMONTH,

     Year(CREATIONDATE) as CREATIONYEAR,

    (WeekDay(date(CREATIONDATE,'DD/MM/YYYY'))&' '&Day(CREATIONDATE) )as CREATIONDAYNAME,

     Time(CREATIONDATE) as CREATIONTIME,

     Hour(CREATIONDATE) as CREATIONHOUR,

a single date separating the whole body

3.esquema: donde se reune todo en un qvd final

and now in the final model, performing the analysis set facilitates many things

CREATIONYEAR = {'$(=Max(CREATIONYEAR))','$(=Max(CREATIONYEAR)-1)','$(=Max(CREATIONYEAR)-2)'}

for example

[nishanthi_8]

What is the key field used to join both the tables ? Are you using "Month" field from first qvd ?

[qlikviewwizard]

What is the format of RMRMonth? Is it YYYYMM?

If yes, please use this:

DATE(DATE#(RMRMonth,'YYYYMM'),'YYYYMM') >=DATE(MakeDate(2018, 5),'YYYYMM')

Refrence:

Why don’t my dates work?