topic Re: conditional expressions (hide/show) in QlikView

conditional expressions (hide/show)

Thu, 02 Jun 2016 18:25:28 GMT

Re: conditional expressions (hide/show)

sunny_talwar — Thu, 02 Jun 2016 18:29:34 GMT

May be try this:

Only({<1>} [% Month Overall TD]) <= Max([% Month Overall TD])

Re: conditional expressions (hide/show)

sunny_talwar — Thu, 02 Jun 2016 18:30:40 GMT

or this:

Only({<1>} [% Month Overall TD]) = Max([% Month Overall TD]) or Only({<1>} [% Month Overall TD]) = (Max([% Month Overall TD]) - 1)

Re: conditional expressions (hide/show)

Thu, 02 Jun 2016 18:39:22 GMT

thank you for your quick responses Sunny T. I've tried all your suggestions and they don't work.

Re: conditional expressions (hide/show)

sunny_talwar — Thu, 02 Jun 2016 18:42:11 GMT

Sorry, I had a typo, can you try this:

Only({1} [% Month Overall TD]) <= Max([% Month Overall TD])

Re: conditional expressions (hide/show)

Thu, 02 Jun 2016 18:47:16 GMT

I just put in your new expression ' =Only({1} [%Month Overall TD]) <= Max([%Month Overall TD]) 'into a text box for testing purposes, and it is not evaluating it because it has an '-'. However, when I use this expression '=Only({<1>} [%Month Overall TD]) = Max([%Month Overall TD]) ', it is evaluating it as a '-1'.

Re: conditional expressions (hide/show)

sunny_talwar — Thu, 02 Jun 2016 18:50:38 GMT

I know what the problem is. You need to provide set analysis condition here:

Only({1<[% Month Overall TD] = {1}>} [% Month Overall TD]) <= Max([% Month Overall TD])

Replace 1 with whatever the value of Month is for the particular expression

Re: conditional expressions (hide/show)

Thu, 02 Jun 2016 19:00:46 GMT

the field [%Month Overall TD] is a numeric value. For Nov 2013 it would be '1', however, for Nov 2014 it would be '13'. I apologize, but when you say replace the 1 with whatever the value of the Month, it would be different for every year because it would be 1 in Nov2013, but 13 in Nov2014.

Re: conditional expressions (hide/show)

sunny_talwar — Thu, 02 Jun 2016 19:04:45 GMT

How about this:

Nov would show up for when Nov is selected and Dec is selected, right? Assuming Nov-2013 is a 1 and Nov-2014 is a 13, try this for Nov expression:

Nov

Mod([% Month Overall TD], 12) = 1 or Mod([% Month Overall TD], 12) = 2

Dec

Mod([% Month Overall TD], 12) = 2 or Mod([% Month Overall TD], 12) = 3

...

Re: conditional expressions (hide/show)

Thu, 02 Jun 2016 19:38:20 GMT

Hi Sunny:

I think we are getting close to the solution. It looks like it work for Nov, Dec, and Jan when it is selected. However, when I select Feb, only Nov, Jan, and Feb shows. If I select Mar, only Nov, Feb, and Mar shows.

To be precise, when Nov-2013 is selected the %Month Overall TD is 61 and when Nov-2014 is selected it is 73, a change in 12(12 months).

Trung

Re: conditional expressions (hide/show)

Thu, 02 Jun 2016 19:44:26 GMT

Sunny, I also have a field [Month Number] that is nov=1, dec=2, jan=3, feb=4. Could we use that field for this conditional expression?

Re: conditional expressions (hide/show)

sunny_talwar — Thu, 02 Jun 2016 19:46:39 GMT

Do you mind reiterating what the goal is based on selections? If you select Feb, whT all you want to see?

Re: conditional expressions (hide/show)

Thu, 02 Jun 2016 19:48:43 GMT

Yes, we are based on a fiscal calendar that runs from Nov thru October. So when I select, February, I would like to see the column for Nov, Dec, Jan, and Feb.

Re: conditional expressions (hide/show)

Mon, 13 Jun 2016 23:21:30 GMT

Hi Sunny:

I was wondering if you had any other ideas I could try to help me resolve this issue.

Thanks,

Trung

Re: conditional expressions (hide/show)

sunny_talwar — Mon, 13 Jun 2016 23:51:47 GMT

Would it be possible to share a sample with the expected output?

Best,

Sunny