Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

eugeniyaromanov
New Contributor III

If problem

Hello everyone!

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:

Data table:     

NumberDateTimeFromToGood/Bad
101.01.201700:00:00LondonRigaGood
201.01.201700:00:00RigaLondonGood
301.01.201700:00:00MoscowVilniusBad
401.01.201700:00:00BerlinMilanGood
501.01.201700:00:00MadridKievGood
601.01.201700:00:00KievVilniusGood
701.01.201700:00:00BerlinLondonGood
801.01.201700:00:00MilanMoscowBad
901.01.201700:00:00VilniusRigaBad

Please see the attach with data.

1 Solution

Accepted Solutions
neelamsaroha157
Valued Contributor II

Re: If problem

2 Replies
neelamsaroha157
Valued Contributor II

Re: If problem

eugeniyaromanov
New Contributor III

Re: If problem

Great!

How couldn't I think of this?

Thank you!