topic Re: merging 3 expression into one expression in QlikView

merging 3 expression into one expression

Anonymous — Fri, 11 Sep 2015 10:17:31 GMT

Hello all,

I am three expression say:

RollingMonth as a dimension

PreviousMonth_CurrentYear =sum({<RollingMonth={'$(=VPM)'}>} SalesAmount)

CurrentMonth_CurrentYear =sum({<RollingMonth={'$(=VCM)'}>} SalesAmount)

CurrentMonth_PreviousYear =sum({<RollingMonth={'$(=VCM)'}>} SalesAmount)

where as variable are

VPM= =MonthName(AddMonths(max(SalesDate),-1))

VCM= =MonthName(max(SalesDate))

VCMLY= MonthName(AddMonths(max(SalesDate),-12))

Can I merge these 3 expression into 1 expression by using Pick,Match,WildMatch function etc.

Regards,

Balraj

Re: merging 3 expression into one expression

Anonymous — Fri, 11 Sep 2015 10:18:28 GMT

Take this as:

CurrentMonth_PreviousYear =sum({<RollingMonth={'$(=VCMLY)'}>} SalesAmount)

Re: merging 3 expression into one expression

sunny_talwar — Fri, 11 Sep 2015 10:19:38 GMT

Sure you can, but what will decide which expression to show? A list box?

Re: merging 3 expression into one expression

kavita25 — Fri, 11 Sep 2015 10:23:20 GMT

You can make flags in back end and used in front end...

Re: merging 3 expression into one expression

Anonymous — Fri, 11 Sep 2015 10:25:48 GMT

I need to show all the expression on the base of current selection.

Say, If I have selected Jan 2015, then it shoud show me

Jan 2015,

Dec 2014,

Jan 2014

sales.....

Re: merging 3 expression into one expression

sunny_talwar — Fri, 11 Sep 2015 10:28:56 GMT

Can you try this (Not sure if this will work, but no harm in trying )

=Sum({<RollingMonth={'$(=VPM)', '$(=VCM)', '$(=VCMLY)'}>} SalesAmount)

Re: merging 3 expression into one expression

Anonymous — Fri, 11 Sep 2015 10:29:43 GMT

How I can create Flag at backend for all these..

Say I am having Transaction_ Date..

On what basis I can create a flag??

Re: merging 3 expression into one expression

Anonymous — Fri, 11 Sep 2015 10:31:26 GMT

Not working

Re: merging 3 expression into one expression

sunny_talwar — Fri, 11 Sep 2015 10:40:23 GMT

Check if this is what you want:

Re: merging 3 expression into one expression

kavita25 — Fri, 11 Sep 2015 10:43:21 GMT

Flags will be static...

You want dynamic on the basis of selection..so you can make variables and used it on your expression.

You want one expression to be calculated for all the three logic ???

then,

Hope the below expression will help you..

=sum({<RollingMonth={'$(VCMLY)','$(VCM)','$(VPM)'}>}Sales)

Re: merging 3 expression into one expression

Anonymous — Fri, 11 Sep 2015 10:57:28 GMT

Why its not working on Year or month???

Re: merging 3 expression into one expression

sunny_talwar — Fri, 11 Sep 2015 10:59:11 GMT

You mean why it is not working on a selection in Year or Month Fields? What would you want to see when you make a selection there? We might have to play around with the variables to make it work with selection in those fields.

Re: merging 3 expression into one expression

Anonymous — Fri, 11 Sep 2015 11:04:29 GMT

try:

=sum({<RollingMonth={'>=$(=VCMLY)'}>} SalesAmount)

if not please can you elaborate on what you want to achieve.

Regards

Neetha

Re: merging 3 expression into one expression

sasiparupudi1 — Fri, 11 Sep 2015 11:04:32 GMT

Sunny,

What if the dimension is made as a calculated dimension

only({<RollingMonth={'$(=VPM)', '$(=VCM)', '$(=VCMLY)'}>} RollingMonth)

and expression as

=Sum(SalesAmount)

Sasi

Re: merging 3 expression into one expression

kavita25 — Fri, 11 Sep 2015 11:05:59 GMT

What is your format of Rolling Month field??

Re: merging 3 expression into one expression

sunny_talwar — Fri, 11 Sep 2015 11:06:45 GMT

Not sure how it would work, but definitely worth giving a short.

Re: merging 3 expression into one expression

Anonymous — Fri, 11 Sep 2015 11:32:34 GMT

This would not work as it would be giving you all the values of which is greater then my VCMLY..

Re: merging 3 expression into one expression

Anonymous — Fri, 11 Sep 2015 11:33:02 GMT

I have simply used monthname(date) as rollingmonth

Re: merging 3 expression into one expression

Anonymous — Fri, 11 Sep 2015 11:34:29 GMT

Not working..

Re: merging 3 expression into one expression

sunny_talwar — Fri, 11 Sep 2015 11:40:05 GMT

You did not respond to my question here: