topic Re: How to display filter on a chart? in QlikView

How to display filter on a chart?

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

Hi All,

I want to be able to display just the TRUE values on a graph. Currently how I have it set up is in the Dimensions, I have one field selected (Vendor) which has 3 vendor filters. And then I have three expressions (type of failures) selected. For each expression, they each have TRUE/FALSE filters (TRUE being the failure occurred on the vendor, FALSE being it did not). Right now, the bar graph displays the total count of both TRUE and FALSE values.

I apologize since I am completely new to Qlikview & SQL. Any help is appreciated.

Re: How to display filter on a chart?

MarcoWedel — Wed, 27 Jun 2018 21:22:54 GMT

please post some sample data and your expected result.

Re: How to display filter on a chart?

Anonymous — Thu, 28 Jun 2018 14:48:54 GMT

This is a sample of the data I imported from Excel:

I chose the following for expressions:

And the Vendor for the Dimension:

So in the chart it displays the total count of failures for each vendor.

I would like to know how to display just the true values of each failure type on each vendor. So for example, having vendor A show 3 for Hardware, 1 for Human Error and 1 for Software and then the same for vendors B and C.

Re: How to display filter on a chart?

BalaBhaskar_Qlik — Thu, 28 Jun 2018 16:54:05 GMT

May be try these expressions:

Count({<Software = {"TRUE"}>}Vendor)

Count({<Hardware = {"TRUE"}>}Vendor)

Count({<[Human Error] = {"TRUE"}>}Vendor).

Re: How to display filter on a chart?

Anonymous — Thu, 28 Jun 2018 17:33:11 GMT

Where would I put those expressions? When I put them under conditional, the bars disappear.