Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar Chart

Hi,

Each day i have transactions like Pass & Fail. I have Daily data. I want to show each customer Fail transactions in Hours. Please suggest me

Thanks

2 Replies
t_chetirbok
Creator III
Creator III

Hello!

Do you have some sample qvw with data?

MayilVahanan

Hi

Try  like this

Load *, Hours(DailyDate) As Hours, If(transactions = 'Fail', 1, 0) AS Flag yourTableName;

In Front end,

Hours - Dimension

Count({<Flag = {1} >} Customers)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.