topic Re: Expression in QlikView

Expression

Tue, 30 Aug 2016 09:20:57 GMT

Hi There,

I want to create an expression to look at the the sameday on Current month and previous month, for instance

CM = 20160801 to 20160830

PM = 20160701 to 20160730

Many thanks,

Treasure

Re: Expression

oknotsen — Tue, 30 Aug 2016 09:39:35 GMT

Maybe the inmonth() function is what you are looking for.

inmonth ‒ QlikView

Re: Expression

Anonymous — Tue, 30 Aug 2016 09:42:04 GMT

try addmonths(CM,-1)

how your Expression would look like to Combine sameday value of CM and PM?

Re: Expression

Tue, 30 Aug 2016 10:22:43 GMT

Hi Rudolf,

I have two Charts (one showing CM and the other showing PM)

so on the current month chart(there's data from the first of this month until today),

and on the previous month chart(there's data from the first of the previous month until month end (20160731)

so I want to compare 30th of this month and the 30th of the pm

thanks,

Re: Expression

Anonymous — Tue, 30 Aug 2016 10:50:02 GMT

you may use the Expression with addmonths in your Chart with PM

do you show each day of month in the Chart?

can you post sample qvw?

Re: Expression

Anonymous — Tue, 30 Aug 2016 10:54:00 GMT

may be like this?

Create two variables

1. vCurrentMonth

=Max(Month)

and make ur expression like:

sum( {$<Year = {$(#vCurrentMonth)}>} Sales )

2. vLastMonth

=Max(Month-1)

sum( {$<Year = {$(#vLastMonth)}>} Sales )

For Current Month Sales:

=sum({<CalendarYear={$(=max(CalendarYear))},CalendarMonthName={$(=Month(Max(InvDate)))}>}INVC_ITEM_AMT)

For Last Month Sales:

=sum({<CalendarYear={$(=max(CalendarYear))},CalendarMonthName={$(=month(addmonths((max(InvDate)),-1)))}>}INVC_ITEM_AMT)

Re: Expression

Anonymous — Tue, 30 Aug 2016 10:55:09 GMT

check this as well??

Set Analysis Current Month vs Previous Month

The As-Of Table

Re: Expression

Tue, 30 Aug 2016 11:19:58 GMT

Re: Expression

Anonymous — Tue, 30 Aug 2016 12:24:54 GMT

you wrote that you want to compare the sameday from current month and previous month

but you want to compare the current month vs previous month? or do you select the day by a selection box?

anyway: if you define the Expression for PM like

sum({<yourdatefield={'$(=addmonths(max/(yourdatefield),-1)'}>}value)

you select month: you get months value

you select day and month: you get value of this month/day

Re: Expression

Tue, 30 Aug 2016 12:46:04 GMT

Hi Rudie, It worked(sum({<yourdatefield={'$(=addmonths(max/(yourdatefield),-1)'}>}value)),

THANK you so much

Re: Expression

oknotsen — Tue, 30 Aug 2016 12:50:26 GMT

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .