If Else Statement

[Anonymous]

Hi I'm new on Qlik Sense , I have 2 questions here.

1) Based on the excel, sheet 2, you guys can see the high, medium and low. There are risks for every phase. How can i visualize it?

2) Sheet 1 and sheet 2 is related based on the phase. So, if the project has season factor either monsoon/festive, the risk on sheet 2 will go high as example , from medium, it will go high. And for low, it will go medium. How can i do that, I have an idea to use if else statement, but i didn't find on the internet like if project has season, medium=high, low=medium..

i appreciate anyone who can help me to do this.Thank you