Model Non-Response to Dimension selections

[Anonymous]

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:

1. RETAILPHARMACY
2. 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

[sunny_talwar]

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

[Anonymous]

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.

[sunny_talwar]

"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?

[Anonymous]

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

[sunny_talwar]

Create a table box with following fields

1) RETAILPHARMACY

2) BRANCH

3) Drug Name

4) PRx

and see if you can see something weird...

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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

[sunny_talwar]

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