topic Dimension help in QlikView

Dimension help

tamilarasu — Wed, 06 May 2015 10:43:14 GMT

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

Re: Dimension help

petter — Wed, 06 May 2015 10:52:44 GMT

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

Re: Dimension help

buzzy996 — Wed, 06 May 2015 10:54:59 GMT

try tis,

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

Re: Dimension help

tamilarasu — Wed, 06 May 2015 10:59:52 GMT

Shiva: Tried this but not working.

Re: Dimension help

Gysbert_Wassenaar — Wed, 06 May 2015 11:00:38 GMT

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.

Re: Dimension help

tamilarasu — Wed, 06 May 2015 11:03:33 GMT

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.

Re: Dimension help

tamilarasu — Wed, 06 May 2015 11:04:20 GMT

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.

Re: Dimension help

buzzy996 — Wed, 06 May 2015 11:08:16 GMT

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

Re: Dimension help

petter — Wed, 06 May 2015 11:08:48 GMT

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

Re: Dimension help

awhitfield — Wed, 06 May 2015 11:11:54 GMT

Hi Tamil,

are you able to post your qvw?

Andy

Re: Dimension help

Gysbert_Wassenaar — Wed, 06 May 2015 11:12:58 GMT

Please post a qlikview document that demonstrates the problem.

Re: Dimension help

tamilarasu — Wed, 06 May 2015 11:19:13 GMT

Hi All,

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

Re: Dimension help

tamilarasu — Wed, 06 May 2015 11:31:20 GMT

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.

Re: Dimension help

Gysbert_Wassenaar — Wed, 06 May 2015 11:34:02 GMT

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

Re: Dimension help

Anonymous — Wed, 06 May 2015 11:35:35 GMT

Tamil

Gysbert is correct.

Amended qvw attached :

Re: Dimension help

buzzy996 — Wed, 06 May 2015 11:43:11 GMT

use this,

Re: Dimension help

Anonymous — Wed, 06 May 2015 11:56:25 GMT

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

= if ( Status = 'Received', Status )

and tick Suppress When Value is Null