topic Re: Conditional Expression. in QlikView

Conditional Expression.

renuka_sasikumar — Tue, 10 Feb 2015 07:27:56 GMT

Hi,

I have a CY Sales & PY Sales

Now when I select 2015 I get data for this year but while comparing data with PY I get all the months data but I should only get data as of CY Max month.

For Eg:

2015

JAN

FEB

MAR

APR

MAY

JUNE

JULY

AUG

SEP

OCT

NOV

DEC

TOTAL

CY Sales

XYZ

ABC

PY Sales

XYZ

ABC

Here for PY I should get data only till Feb.

Is there any possible ways.

Thanks & Regards,

Renuka S

Re: Conditional Expression.

Peter_Cammaert — Tue, 10 Feb 2015 07:31:45 GMT

This is a LYTD comparison. Add the following set modifier to your PY expression:

..., Month = {'$(=Max(Month))'}...

This will restrict the last month displayed in PY to the maximum month available in the selected year.

Re: Conditional Expression.

renuka_sasikumar — Tue, 10 Feb 2015 07:48:36 GMT

Hi,

Thanks for immediate reply.

But its not working.

Re: Conditional Expression.

Peter_Cammaert — Tue, 10 Feb 2015 07:52:52 GMT

It should, at least as far as you description goes.

Can you post a sample app with the same behavior? Otherwise we may keep guessing for a while...

Re: Conditional Expression.

Peter_Cammaert — Tue, 10 Feb 2015 07:55:25 GMT

I'm sorry, it shouldn't work. I made a mistake in my suggested modification. What about this one:

..., Month = {'<=$(=Max(Month))'}...

Re: Conditional Expression.

renuka_sasikumar — Tue, 10 Feb 2015 08:17:43 GMT

Hi,

Thanks I did the same Now its working.

Thank you very much.

Thanks & Regards,

Renuka S