topic Pivot Chart - Display only values of a particular dimension based on the value of another dimension in QlikView

Pivot Chart - Display only values of a particular dimension based on the value of another dimension

Anonymous — Thu, 08 Mar 2018 04:22:20 GMT

Hi all,

I have a pivot chart that displays outstanding sales orders by Sales Rep for all customers.

We have two classes of customers : Account or Cash Customers.

I have a multibox in the report to change the display in the chart from Account to Cash Customers based on the field "CustType" (where the value is either 'A' for Account or 'C' for Cash)

I want to have two charts next to each other, one showing Outstanding Orders for Account Customers, and one for Cash Customers.

How do I tell my Account Customers Chart to exclude any orders where the CustType is 'C' and my Cash Customers Chart to exclude any orders where the CustType is 'A'?

I assume this can be done as a calculated dimension or a dimension condition or otherwise a flag within the script that flags the customer as account or cash to create different fields that can be displayed in the different charts.

However not quite sure on what the syntax should be...

Could anyone point me in the right direction?

Thanks in advance....

Re: Pivot Chart - Display only values of a particular dimension based on the value of another dimension

fabdulazeez — Thu, 08 Mar 2018 04:26:03 GMT

I think you can use set analysis in count of sales order.

Count ({$<CustType={'A'}>}SalesOrder)

Re: Pivot Chart - Display only values of a particular dimension based on the value of another dimension

Anonymous — Thu, 08 Mar 2018 04:30:04 GMT

Thanks for your suggestion Fawaz,

I'm not sure if i've ever used set analysis, where would i place that syntax?

Thanks in advance

Fab

Re: Pivot Chart - Display only values of a particular dimension based on the value of another dimension

kakani87 — Thu, 08 Mar 2018 04:58:37 GMT

In dimensions tab there is an option called Add calculated dimension

click on that and add you expression there