topic Re: any other functions other than Getselectedcount in QlikView

any other functions other than Getselectedcount

Chanty4u — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Iam facing an issue in the dashboard

In drill report we are using the dimensions with getselected count function - the problem is in the report we have dimension in the layout and the same dimension is in the filter as well. So whenever we make a selection in the filter section of the dimension, the drill report opens which is unnecessary.

Can anyone suggest me how to solve this.

Thanks in Advance

Re: any other functions other than Getselectedcount

Siva_Sankar — Fri, 09 Jun 2017 02:57:01 GMT

Hi Chanty,

You can use alternate states. Similar discussion with example here Alternate States and Drill-Down Groups

-Siva

Re: any other functions other than Getselectedcount

Chanty4u — Fri, 09 Jun 2017 04:51:52 GMT

Hi Siva,

Is there any other possibility.

Thanks

Re: any other functions other than Getselectedcount

Chanty4u — Fri, 09 Jun 2017 04:57:28 GMT

Iam new to qlikview.

I have a summary report on top and the detailed report on the drill down.

The problem here is when i use the getselectedcount() in the drilldown report. Though i select the dimension element from the layout or from the filter section. the drilldown report or detailed report is appearing this is causing the users an issue.

Thanks

P.Ravikiran

Re: any other functions other than Getselectedcount

Anil_Babu_Samineni — Fri, 09 Jun 2017 05:39:51 GMT

How you are identify the Drill Down field? Can you share full expression.

Re: any other functions other than Getselectedcount

Siva_Sankar — Fri, 09 Jun 2017 05:56:27 GMT

Hi Chanty,

As mentioned in my above post, Qlik's default behavior is that it will apply filter across the dashboard. Unless you create alternate states and apply them for sheets or chart, by default one selection in one sheet gets applied to all sheets and charts available in your qv document.

For more understanding on alternate states please check here Examples of Alternate States in Chart Expressions ‒ QlikView

or here what is alternate states in Qlikview ?

-Siva

Re: any other functions other than Getselectedcount

Chanty4u — Fri, 09 Jun 2017 06:15:35 GMT

Hi Anil.

We are using the below expression.

(GetSelectedCount([G Account])>0 and GetSelectedCount([Gr Account])>0 and GetSelectedCount([GL Desc])>0 and GetSelectedCount([GL Grp Desc])>0) or (GetSelectedCount([BP Ety])>0 and GetSelectedCount([BP Ety Desc])>0)

Re: any other functions other than Getselectedcount

Anil_Babu_Samineni — Fri, 09 Jun 2017 06:17:59 GMT

Those are simple field names/Group names?

Re: any other functions other than Getselectedcount

Chanty4u — Fri, 09 Jun 2017 06:27:16 GMT

We are using only straight table for both summary report and the drill down report

Re: any other functions other than Getselectedcount

Chanty4u — Fri, 09 Jun 2017 06:27:53 GMT

they are simple field names