topic Re: if nohting selected in QlikView

if nothing selected

Wed, 17 Jun 2015 12:28:24 GMT

I have a variable with two parameters, e.g. use 6 and 12 month back, and I use MonthSerial (you know max bla bla, I dont think it matters for this).

When I select in eg a year in the master calendar it works fine, but when all is clear, it does not know from where to count.

So I need to tell it that when nothing is selected take the max year.

What is the easiest way do to this?

Re: if nohting selected

Anonymous — Wed, 17 Jun 2015 12:32:39 GMT

Would the GetPossibleCount() function help you ?

Re: if nohting selected

alexandros17 — Wed, 17 Jun 2015 12:33:04 GMT

use the getselectedcount() function to know if a field is selected so write something like:

If(getselectedcount(myField)=0, Max(myField), getselectedfield(myField))

Re: if nohting selected

swuehl — Wed, 17 Jun 2015 12:33:10 GMT

Well, I assume the max() function will also be your friend here.

But why don't you just post your variable definition and other relevant information, this would make it much easier to help.

Re: if nohting selected

sunny_talwar — Wed, 17 Jun 2015 12:34:53 GMT

I would used Max(Year) regardless of selection or no selection, because when there is no selection made it will choose the maximum year and when a selection is made it will choose the max from the available years. (Unless you don't want the max year when a selection is made, Max(Year) should work.

Best,

Sunny

Re: if nohting selected

Wed, 17 Jun 2015 12:47:24 GMT

Well I tried this:

if(getselectedcount(Year)<1,Round(sum({<MonthSerial={"=Max(MonthSerial)"}>} ($(Interval(6,12))))),Round($(Interval(6,12))))

it does not work. It should be able to translate from year to monthserial?

Re: if nohting selected

Wed, 17 Jun 2015 12:48:57 GMT

thx but I think getselectedcount() is better as suggested?

Re: if nohting selected

swuehl — Wed, 17 Jun 2015 12:52:29 GMT

What is the definition of variable Interval(x,y)?

Seems like you included it into an aggregation, which will not work if it's an aggregation itself.

Re: if nohting selected

Wed, 17 Jun 2015 13:22:02 GMT

hmm, well yes that is probaly true, it works when I select.

The varaible is longer, I cannot show all, but it starts like this: ...((Sum({$<YearMonth,Year,Month,,MonthSerial={"<=$(=Max(MonthSerial)-$1)>=$(=Max(MonthSerial)-$2)"},...

so there you have the parameters.

Re: if nohting selected

swuehl — Wed, 17 Jun 2015 13:31:30 GMT

Well, there you go. Embedding an aggregation function within an aggregation function will not work (in general, e.g without using advanced aggregation).

If you cleared all selection, what does your variable return? I would assume it's still working beacuse you are applying a ranges selection for MonthSerial based on Max(MonthSerial).

Re: if nohting selected

Wed, 17 Jun 2015 13:39:04 GMT

Thanks and yes that is the problem, it only works when I select, as it is told to take max from selected (eg year) and then calculate (I assume).

So I "just" need to say when no select, take max year of all possible.

Re: if nohting selected

Wed, 17 Jun 2015 15:16:33 GMT

Should be possible?

Re: if nohting selected

swuehl — Wed, 17 Jun 2015 15:30:54 GMT

Sure, why not?

If you want more detailed help, you would need to post more complete data.

I can't tell what the issue from what you've posted so far.

If you could post a small sample QVW, this would be best.

Re: if nohting selected

Chanty4u — Thu, 18 Jun 2015 03:45:53 GMT

Max(year) u can use

or else u want to display last selected year

u chk the always one selected value.

it wil gves u last selected year wen open the qvw.

Hope this helps you

Thank u

Suresh

Re: if nohting selected

Wed, 24 Jun 2015 07:51:05 GMT

Thanks, I believe the problem was that there is not enough data, that is why it was not showing anything, so my diagnose was wrong, I appologize.