topic Conditional Filter and Create A Bar Chart in QlikView

Conditional Filter and Create A Bar Chart

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

Dear Qlikview Experts,

I have this set of data as shown on the left hand side and i would like to create a bar chart as shown on the right side.

Basically, I have a couple of errors, and the error will turn to '1' when occur and latch on all the way until it has been cleared and the value will turn back to '0'. So I would like to create a bar chart to display what are the type of errors that have happen on a particular day and the number of times it had happened.

Thank you so much for your help in advance!

Best Regards

QianNing

Re: Conditional Filter and Create A Bar Chart

amrinder — Wed, 27 Mar 2019 05:56:02 GMT

Hi,

Convert various Error column headers into rows using Crosstable like below:

Crosstable(ErrorType,ErrorStatus,2)

Load

Date,

Time,

Error1,

Error2,

Error3,

Error4,

Error5,

Error6

From XYX.xlsx;

Hope it helps.

-amrinder