topic Re: Select certain field on chart in QlikView

Select certain field on chart

kylealpaugh — Wed, 25 Nov 2020 16:16:04 GMT

I have a chart and i one of the columns shows net price i was wondering how i could show the net price of a value that is in a different field. The field i get net price from is [Net Order Value_NETWR_line]) but the field that the value is in is [Order Document Type_AUART_line]) and the value in [Order Document Type_AUART_line]) is ZWEB that i want to set.

Re: Select certain field on chart

Digvijay_Singh — Thu, 15 Mar 2018 18:45:43 GMT

Can you share some sample data/image of chart etc to understand the real need.

Re: Select certain field on chart

kylealpaugh — Thu, 15 Mar 2018 18:56:49 GMT

This is the Chart. I am currently filtering the field with a list box but i want to set it up so it always stay filtered with ZWEB

Re: Select certain field on chart

Digvijay_Singh — Thu, 15 Mar 2018 19:06:56 GMT

Do you mean you want to show Net Price always for Sales Doc Type='ZWEB' irrespective of you made selections to 'CR','DR', 'KB' etc in the list box?

If Yes, then use Set expression like Sum({<[Sales Doc Type]={'ZWEB'},[Sales Doc Type]>}[Net Price]) to disregard the selections made in the list box.

Re: Select certain field on chart

PrashantSangle — Thu, 15 Mar 2018 19:08:32 GMT

why don't you set it in your set analysis

sum({<[Order Document Type_AUART_line]={'ZWEB'}>} [Net Order Value_NETWR_line])

Regards

Re: Select certain field on chart

kylealpaugh — Thu, 15 Mar 2018 19:13:53 GMT

the column field net price is an expression "sum({<Source={'Order_line'}>}[Net Order Value_NETWR_line])"

How Could i set ZWEB to only how if i already have an expression for the net price column

Re: Select certain field on chart

kylealpaugh — Thu, 15 Mar 2018 19:13:58 GMT

the column field net price is an expression "sum({<Source={'Order_line'}>}[Net Order Value_NETWR_line])"

How Could i set ZWEB to only how if i already have an expression for the net price column

Re: Select certain field on chart

PrashantSangle — Fri, 16 Mar 2018 08:06:53 GMT

sum({<Source={'Order_line'},[Order Document Type_AUART_line]={'ZWEB'}>}[Net Order Value_NETWR_line])

Regards,