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

Regarding the if conditional clause with multiple conditions

Hi All,

Can you please suggest me in writing the condition in the script level.

Scenario:

Subjects:

Maths,

Physics,

Social,

Telugu

At present my dashboard is excluding the students who knows maths and physics.

But could you please suggest me to write a condition such that I should nt get the count of even the students who knows (Maths,Physics and Social),(Maths and Social),(Physics and Social).

Thanks in advance.

Regards,

Anu

10 Replies
isingh30
Specialist
Specialist

If i am correct you need count of students only for Telugu subject? If yes, you can use where clause in the main script stating subject = Telugu. Let me know.

Thank you!

ak00428233
Contributor III
Contributor III
Author

Hi Ishtdeep,

Yeah I can write in the script part stating subject =Telugu but what the dashboard is giving is the information of students who studied maths and telugu also.

The issue was with my business scenario but I have modified into this subject scenario.So could you please suggest me such that students who study (Maths and Telugu)  both shouldn't reflect to the report.

Thanks in advance.

isingh30
Specialist
Specialist

Can you share your data or app?

Thanks

ak00428233
Contributor III
Contributor III
Author

Could you please give me your email id. I will send you the issue,scenario and data.

ak00428233
Contributor III
Contributor III
Author

Hi Ishtdeep,

The screenshot of the script

Where 2 access levels people are restricted but could you please the condition to restrict the people who have access of (Admin and R.admin) and also (Admin,M.Admin and R.Admin).

Thanks in advance.

ak00428233
Contributor III
Contributor III
Author

Data

isingh30
Specialist
Specialist

Try this - where Level = 'User'

This will work. Names are not clashing.

Thank you!

ak00428233
Contributor III
Contributor III
Author

Hi Ishtdeep,

When i try to view the details of 'User' and 'R.Admin'.It is not working.Can you please suggest to get the details for these level access.