topic Re: Issue of date field in QlikView

Issue of date field

Thu, 05 Dec 2013 07:54:02 GMT

Dear All.

i have data like jan,feb,mar,apr,may,june,july,Aug.

in that some times i want total data like Jan to Aug-------->this is one expression

second one i want total data like Jan to July only here i don't want Aug month data -------------this is second expressions

Thanks & Advance

Babu

preminqlik — Thu, 05 Dec 2013 08:02:13 GMT

helo there,

first expression :
sum({<Month={'Jan','Feb','Mar','apr','May','Jun','jul','Aug'}>}Sales)

Second Expression :

sum({<Month={'Jan','Feb','Mar','apr','May','Jun','jul'}>}Sales)

regards

Premhas

Thu, 05 Dec 2013 08:18:29 GMT

i want based on date field only, i don't want month field

Thu, 05 Dec 2013 08:37:40 GMT

Can u pls givve the clarification or screen shot

i hope u want the to show the data in list box jan to july u can write expression in list box using match function

in second list box u can write expression for others too

Anonymous — Thu, 05 Dec 2013 08:40:11 GMT

Hi Babu,

sum({<Date={">=$(=yearstart(today()))<=$(=makedate(2013,8,31))"}>}Sales)

Second Expression :

sum({<Date={">=$(=yearstart(today()))<=$(=makedate(2013,7,31))"}>}Sales)

Try in this form, hope it will help you

Regards

Nitin

jagan — Thu, 05 Dec 2013 08:58:36 GMT

Hi,

If you have a date dimension in your data model then use below expressions

=Sum({<MonthDimensionName=, DateDimensionName={">=$(=YearStart(Today()))<=$(=MakeDate(2013,8,31))"}>}Sales)

Second Expression :

=Sum({<MonthDimensionName=, DateDimensionName={">=$(=YearStart(Today()))<=$(=MakeDate(2013,7,31))"}>}Sales)

Hope this helps you.

Regards,

Jagan.