Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.