ad-hoc reporting issue

[stonecold111]

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..

[stonecold111]

why two dimensions are getting selected for one selection

Qlikssss.....suggest

[mayankraoka · Accepted solution]

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

[rahulpawarb]

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

[stonecold111]

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