Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

I have a sample dataset column into this format '2015-01-01' I want to re retrieve theose year whose months are June. What will be the query??

I have a sample dataset column into this format '2015-01-01' I want to re retrieve theose year whose months are June. What will be the query??

Thanks.

Bibhuti

4 Replies

Re: I have a sample dataset column into this format '2015-01-01' I want to re retrieve theose year whose months are June. What will be the query??

Every year has a June Month, not sure what you are trying to do? Do you want to extract June from each year in the script?

May be this:

LOAD YourFields,

          Date#(DateField, 'YYYY-MM-DD') as DateField

FROM Source

Where Num(Month(Date#(DateField, 'YYYY-MM-DD'))) = 6;

Re: I have a sample dataset column into this format '2015-01-01' I want to re retrieve theose year whose months are June. What will be the query??

What you mean by those years whose months are June. Can you please give more information on your requirements?

balrajahlawat
Esteemed Contributor

Re: I have a sample dataset column into this format '2015-01-01' I want to re retrieve theose year whose months are June. What will be the query??

If it is for June only, at script try WhatSunny T

has suggested you else at UI you can try like this?

Assume at script,

month(date) as Month

=sum({<Month={'6'}>} Sales)  //This will give you June records only

reddys310
Honored Contributor II

Re: I have a sample dataset column into this format '2015-01-01' I want to re retrieve theose year whose months are June. What will be the query??

Hi Bibhuti,

As Sunny Mentioned the month() function should help you achieve what you are looking for. In addition to that, make use of a master calender and other date functions to simplyfy your front end calculations like:

year()

week()

WeerName()

inYear()

inYeartoDate() etc.... Check the script manual for detailed info on all the date functions.

Thanks,

Sangram

Community Browser