topic Re: bookmark alternate state in GetSelectedCount method in QlikView

bookmark alternate state in GetSelectedCount method

Anonymous — Mon, 09 Mar 2015 19:41:27 GMT

Helo,

Is it possible to use a bookmark's alternate state in GetSelectedCount method?

GetSelectedCount (Field1) returns count of selected Field1 values

GetSelectedCount (Field1, 'false', 'AltSt1') returns count of selected Field1 values in alternate state AltSt1.

I want to get count of selected Field1 values in alternate state AltSt1 in bookmark BM01.

I tried GetSelectedCount (Field1, 'false', 'AltSt1::BM01') but that doesnt return any value.

Is there a different syntax?

Thanks,

Re: bookmark alternate state in GetSelectedCount method

sindu_bharathi — Tue, 10 Mar 2015 10:19:15 GMT

Hi Vijay,

GetSelectedCount(),GetFieldSelections(),etc functions will not work with Alternate States.

to get its count you can use like below

substringcount(concat(alternateStateField,'|'),|)

Regards,

Siindu

Re: bookmark alternate state in GetSelectedCount method

Gysbert_Wassenaar — Tue, 10 Mar 2015 12:32:16 GMT

Use of Alternate States in the GetSelectedCount function is available in QV 11.2 SR8 and newer. But AltSt1::BM01 is set analysis syntax. Set analysis is not supported in the Get* functions afaik.

Re: bookmark alternate state in GetSelectedCount method

Anonymous — Tue, 10 Mar 2015 14:06:59 GMT

So how is bookmark's alternate state handled in get functions? Or is usage of bookmark's alternate state not supported in GetSelectedCount function?

Re: bookmark alternate state in GetSelectedCount method

Gysbert_Wassenaar — Tue, 10 Mar 2015 14:12:10 GMT

Bookmarks don't have alternate states.

edit: well, that could be argued either way I suppose.

Re: bookmark alternate state in GetSelectedCount method

Anonymous — Tue, 10 Mar 2015 14:16:54 GMT

Apparently they do. When a bookmark is saved, all states are saved and we can refer individual states within a bookmark using AltSt1::BM01 syntax in set analysis. So far it looks like this is not possible in get methods.

Re: bookmark alternate state in GetSelectedCount method

Gysbert_Wassenaar — Tue, 10 Mar 2015 14:31:19 GMT

AltSt1::BM01 syntax in set analysis

Like you said and as I said earlier: in set analysis. The Get* functions do not support set analysis.

Re: bookmark alternate state in GetSelectedCount method

Anonymous — Tue, 10 Mar 2015 14:34:34 GMT

I understand that. Thank you. Just wondering if there is any other syntax I could use in get functions to refer bookmark's alternate state.

Re: bookmark alternate state in GetSelectedCount method

Gysbert_Wassenaar — Tue, 10 Mar 2015 14:35:43 GMT

No, not in the Get* functions. You will have to use a regular count or concat expression.