topic Re: How do I display data depending on condition? in QlikView

How do I display data depending on condition?

Thu, 04 Aug 2011 10:55:00 GMT

I have a table that contains a Customer_Type_ID field with the numbers 1 to 5, and another field called 'Grouping'.

I would like to display a pie chart that shows data where the customer_type_id is not equal to '1'. How do I set this condition in the Expression tab?

Please help.

Many thanks

Re: How do I display data depending on condition?

Miguel_Angel_Baeyens — Thu, 04 Aug 2011 11:00:15 GMT

Hi,

Say you want to show the sum of Sales for all groups except for the "1". The expression would be

Sum({< Customer_Type_ID -= {1} >} Sales)

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

How do I display data depending on condition?

rahulgupta — Thu, 04 Aug 2011 11:02:14 GMT

Can u send a sample Data.

also clarify ur requirmnts.

Re: How do I display data depending on condition?

Thu, 04 Aug 2011 11:12:08 GMT

Hi Miguel

thank you but that didn't work. I will attach a sample of the spreadsheet to make it clearer.

Re: How do I display data depending on condition?

Miguel_Angel_Baeyens — Thu, 04 Aug 2011 11:23:21 GMT

Hi,

The attached data doesn't have transactions, so I cannot sum or aggregate values. The only difference from my code above is taht, as you know, QlikView is case sensitive for both field names and values, and I typed Customer_Type_ID instead of Customer_type_ID (note the lowercase "t" in "type").

So this expression should work

Sum({< Customer_type_ID -= {1} >} Sales)

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: How do I display data depending on condition?

SunilChauhan — Thu, 04 Aug 2011 11:28:10 GMT

Please try attached file

Re: How do I display data depending on condition?

Thu, 04 Aug 2011 11:30:57 GMT

Hi Sunil

Thank you but, it won't let me open it because I am using a Personal Edition License.

How do I display data depending on condition?

SunilChauhan — Thu, 04 Aug 2011 11:34:02 GMT

take a pie chart

in dimension write

if(Customer_type_ID<>1,Customer_type_ID)

and supress null( check the checkbox)

in dimension

write

Count(Grouping)

Re: How do I display data depending on condition?

Miguel_Angel_Baeyens — Thu, 04 Aug 2011 11:38:26 GMT

Hi,

As a general rule, I try to avoid calculated dimensions whenever possible, because they perform extremely poor. When the data volume is higher than a few thousands of lines, the rendering of the chart takes considerably longer using a calculated dimension instead of a set analysis expression (or even a conditional expression).

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: How do I display data depending on condition?

Thu, 04 Aug 2011 15:18:55 GMT

Thanks Sunil. It worked with your suggestion.

Miguel - I will bear your 'general rule' in mind. Thanks for the heads up.