Discussion board where members can get started with QlikView.
I have a problem I can't handle...
I need to write IF for many rows to have one row in the end
I have 2 tables:
1st Data table:
Where I can see date, time and a route.
And I have 2nd table with statuses:
Two of them is good and one is bad.
I need to understand which number is good and which is bad.
So, if all statuses are good, number is good, and if number has even 1 bad status, I need to display it as a bad number.
In the end, from this data I need table like this:
Please see the attach with data.
Go to Solution.
Check this out
View solution in original post
How couldn't I think of this?