Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Conditional Filter and Create A Bar Chart

Dear Qlikview Experts,

Capture.PNG

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

1 Solution

Accepted Solutions
Highlighted
Creator
Creator

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

View solution in original post

1 Reply
Highlighted
Creator
Creator

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

View solution in original post