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

[petter]

The simplest would be to create an Alternate State called as.NotReceived and make a selection of the field with the status flag in that particular Alternate State. Then you could assign you chart to this Alternate State instead of <inherited> or <default> and everything in the chart would relate to Not Received....

[buzzy996]

try tis,

go to ur status flag field and set like this status flag='Received'

[tamilarasu]

Shiva: Tried this but not working.

[Gysbert_Wassenaar]

Change your expression(s) into a set analysis expression(s). For example sum(Amount) would become sum({<Status={'Received'}>}Amount).

Note, make sure to use the exact case sensitive field names. STATUS, status and Status are three different fields to Qlikview.

[tamilarasu]

Gysbert: I have done that in expression. My total customer is 150 and I received only 75 files. so the lines should be 75 but i am getting 150 lines. I guess we need to do something in dimension.

[tamilarasu]

Petter: Checking your solution and I have added a alternate state in document properties. But I dont understand how to select sales status and assign that in chart as I am new to Qlikview.

[buzzy996]

if possible share ur app,tht helps to answer quickly.

[petter]

Mind you if you need selections from you default state to take effect in your alternate state also in addition to having a particular value selected then you have to make adjustments for that too...

[awhitfield]

Hi Tamil,

are you able to post your qvw?

R

Andy