topic Re: Model Non-Response to Dimension selections in QlikView

Model Non-Response to Dimension selections

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

I have the following Qlikview model part:

The model does not respond to the MasterCalendar selections and the selections of the following dimensions in the model:

RETAILPHARMACY
BRANCH

for the ProductScriptCount table only.

The ProductScriptCount table is created from the MainData2 table using a Count Distinct and Group By script in the front end of the application.

What could be the cause of this behaviour?

Regards.

Message was edited by: Christopher Chitemerere

Re: Model Non-Response to Dimension selections

sunny_talwar — Tue, 22 Aug 2017 18:25:13 GMT

Do you have set analysis to ignore selections or have alternate states in your application??

Re: Model Non-Response to Dimension selections

Anonymous — Tue, 22 Aug 2017 18:34:32 GMT

Thanks Sunny

No I do not have, all the other tables change on selection of the stated dimensions except for the ProductScriptCount table values. I have edited my discussion question to clarify this.

Re: Model Non-Response to Dimension selections

sunny_talwar — Tue, 22 Aug 2017 18:55:57 GMT

"The ProductScriptCount table is created from the MainData2 table using a Count Distinct and Group By script in the front end of the application."

Created in the backend you mean?

Re: Model Non-Response to Dimension selections

Anonymous — Tue, 22 Aug 2017 19:16:32 GMT

Yes with the following script:

I then created a table box in the front end using PRx and [Drug Name] fields which does not respond to the selections mentioned before.

Regards

Re: Model Non-Response to Dimension selections

sunny_talwar — Tue, 22 Aug 2017 19:23:35 GMT

Create a table box with following fields

1) RETAILPHARMACY

2) BRANCH

3) Drug Name

4) PRx

and see if you can see something weird...

Re: Model Non-Response to Dimension selections

Anonymous — Tue, 22 Aug 2017 19:45:54 GMT

Many thanks, the table box looks as follows:

It is responding to RETAILPHARMACY AND BRANCH selections except for the PRx value which is not changing but is expected to change. I have deleted the RETAILPHARMACY and BRANCH values as they are confidential.

Regards.

Re: Model Non-Response to Dimension selections

Anonymous — Tue, 22 Aug 2017 20:01:14 GMT

Hi Sunny

Here are the results of the query executed in SQL Server with no filters.

These are the same results i get when when i create a table box in the back end.

When i put a date filter to the same query i get the following results:

This is what should be expected and should change with further filtering of Branch or Retail Pharmacy

Re: Model Non-Response to Dimension selections

Anonymous — Tue, 22 Aug 2017 20:51:51 GMT

Sunny, further to my last response, i have noticed the weirdness as per your mention as follows:

The PRx value is not changing it remains constant and the drug name is repeated per Branch. and retail pharmacy

Re: Model Non-Response to Dimension selections

sunny_talwar — Wed, 23 Aug 2017 13:00:01 GMT

May be you want to aggregate over Drug Name and Date to get what you want

So add date to the Select statement and Group By statement

Re: Model Non-Response to Dimension selections

sudeepkm — Wed, 23 Aug 2017 13:26:31 GMT

Regarding your Master Calendar and MainData2 tables association, could you pls check the subset ratio on each table?