topic Re: Regarding the if conditional clause with multiple conditions in QlikView

Regarding the if conditional clause with multiple conditions

ak00428233 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Regarding the if conditional clause with multiple conditions

isingh30 — Fri, 02 Mar 2018 19:49:12 GMT

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!

Re: Regarding the if conditional clause with multiple conditions

ak00428233 — Fri, 02 Mar 2018 20:02:56 GMT

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.

Re: Regarding the if conditional clause with multiple conditions

isingh30 — Fri, 02 Mar 2018 20:16:58 GMT

Can you share your data or app?

Thanks

Re: Regarding the if conditional clause with multiple conditions

ak00428233 — Fri, 02 Mar 2018 20:24:07 GMT

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

Re: Regarding the if conditional clause with multiple conditions

isingh30 — Fri, 02 Mar 2018 20:26:58 GMT

ishtdeepsingh@outlook.com

Re: Regarding the if conditional clause with multiple conditions

ak00428233 — Sat, 03 Mar 2018 09:00:39 GMT

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.

Re: Regarding the if conditional clause with multiple conditions

ak00428233 — Sat, 03 Mar 2018 09:02:19 GMT

Data

Re: Regarding the if conditional clause with multiple conditions

isingh30 — Sat, 03 Mar 2018 09:58:30 GMT

Try this - where Level = 'User'

This will work. Names are not clashing.

Thank you!

Re: Regarding the if conditional clause with multiple conditions

ak00428233 — Sat, 03 Mar 2018 11:23:43 GMT

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.

Re: Regarding the if conditional clause with multiple conditions

ak00428233 — Sat, 03 Mar 2018 16:01:03 GMT

Hi Ishtadeep,

I even tried with

[Level] <> 'M.Admin'

and [Level] <> 'Admin'

and [Level] <> 'Admin'+'M.Admin'

and [Level] <> 'Admin'+'M.Admin'+'R.Admin'

and [Level] <> 'R.Admin'+'M.Admin';

but still there are few issues.