topic ad-hoc reporting issue in QlikView

ad-hoc reporting issue

stonecold111 — Tue, 25 Apr 2017 07:38:51 GMT

in ad-hoc reporting if i select one dimension, two dimensions are getting selected in pivot table

this is happening for only one dimension, remaining dimensions working normally

what could be the reason

dimensions:

Prod\Prod fev (PH)

Prod\Prod fev Alt (PH1)

when i select Prod\Prod fev Alt (PH1) in dimensions

both dimensions are getting displayed in pivot table

Suggest qlikss..

Re: ad-hoc reporting issue

stonecold111 — Tue, 25 Apr 2017 08:50:59 GMT

why two dimensions are getting selected for one selection

Qlikssss.....suggest

Re: ad-hoc reporting issue

mayankraoka — Tue, 25 Apr 2017 09:07:27 GMT

Hi Suresh,

The reason for this is because of common name.When you select Prod\Prod fev Alt it will pass the condition for Prod\Prod fev as well.Hence both get selected.

Regards,

Mayank

Re: ad-hoc reporting issue

rahulpawarb — Tue, 25 Apr 2017 09:10:54 GMT

Hello Suresh,

Could you please share the application as well as expression used to populate & control the dimension? This will help us to locate the exact issue and provide you required inputs.

Regards!

Rahul

Re: ad-hoc reporting issue

stonecold111 — Tue, 25 Apr 2017 11:20:09 GMT

yes. you are right. we used conditional string that matches for both dimensions

i used just PH1 not entire Prod\Prod fev Alt (PH1) , so it matched for both

anyway thanks