Dimension help

[tamilarasu]

Hi,

I have a table which created from multiple sources. I have column called "Status" and in that i have "Received" and "Not received" as status flag. Previously the pivot chart has been created with entire data. Now I want to show the data only for "Received" files. Below are the dimensions. Can any one tell me how to amend the chart with the status flag (also i dont want to show this column. Is there any set analysis or calculated dimension)?

Dimensions:

Customer Name

Customer Number

Sales Rep Name

Sales Rep number

[Gysbert_Wassenaar]

Please post a qlikview document that demonstrates the problem.

[tamilarasu]

Hi All,

Wait. I am not allowed to post original qvw. I'll post a sample one.

[tamilarasu]

Andrew, Gysbert and Shiva: See the below attachment.

I dont want to show C and D customers in the chart since the status is mentioned as "Not Received" (see in load script).

Hope this sample is fine. Please let me know, if its not sufficient.

[Gysbert_Wassenaar]

Change your count expression too: count({<Status={'Received'}>}[Customer Number])

[Anonymous]

Tamil

Gysbert is correct.

Amended qvw attached :

[buzzy996]

use this,

[Anonymous · Accepted solution]

... or remove the Set Analysis from the Expression and use this Calculated Dimension

= if ( Status = 'Received', Status )

and tick Suppress When Value is Null