topic Re: How to use and condition in if statement in QlikView

How to use and condition in if statement

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

Hi ,

How can i use and condition in if condition?requirement is like,when they select high and medium count should be 0 otherwisse

count({<rating={'low','TBD','very low'}>}ID) i tried if condition with and but whenever i am making selection of high and medium it is not showing 0

rating

high,

low,

medium,

TBD,

very low]

Please help me to resolve this.

Regards,

shruthi

Re: How to use and condition in if statement

sunny_talwar — Sun, 10 Jul 2016 16:15:30 GMT

May be this:

Alt(Count({<rating={'low','TBD','very low'}>}ID), 0)

RangeSum(Count({<rating={'low','TBD','very low'}>}ID), Sum({1} 0))

Re: How to use and condition in if statement

shruthibk — Sun, 10 Jul 2016 16:23:53 GMT

both are not working for my requirement ,Rating is provided as filter,so whenever user make selection of high and medium it should show 0, else by default it should show count for low ,TBD and very low

Re: How to use and condition in if statement

sunny_talwar — Sun, 10 Jul 2016 16:25:44 GMT

Are you trying to see this in a straight table? Have you made sure to unchec 'Suppress Zero-Values' on the presentation tab?

Re: How to use and condition in if statement

shruthibk — Sun, 10 Jul 2016 16:28:49 GMT

i am trying in text box as i need to display only counts

Re: How to use and condition in if statement

sunny_talwar — Sun, 10 Jul 2016 17:44:28 GMT

Try this:

Count({<rating *= {'low','TBD','very low'}>} ID)

Re: How to use and condition in if statement

vinieme12 — Sun, 10 Jul 2016 18:36:12 GMT

Try This

=Count({<Rating = {'Low','very Low','TBD'},Rating -= {'High','Medium'}>}ID)

Re: How to use and condition in if statement

vikramv — Sun, 10 Jul 2016 20:10:04 GMT

Try like....

=if(Match(getfieldselections(Rating),'high','medium'),0,count({<Rating={'low','TBD','very low'}>}ID))

Re: How to use and condition in if statement

shruthibk — Mon, 11 Jul 2016 06:40:18 GMT

Hi if i select either high or medium it is giving 0 but but when i select both it is giving count,it should give 0 when i select both

Re: How to use and condition in if statement

shruthibk — Mon, 11 Jul 2016 06:42:14 GMT

Thank you

Re: How to use and condition in if statement

qliksus — Tue, 12 Jul 2016 04:19:40 GMT

May be something like this

count({<Desc={"=match(Desc,'High','Med')=0 and GetSelectedCount(Desc)<=1"}>}Desc)