topic Re: List in QlikView

List

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

Hi All,

=IF(sales > 0, 0, 1)and IF(Brand='maruthi',0,1)

In a list box i have the above condition for in the layout ,

can someone explain what is this doing ?

Re: List

rahulpawarb — Fri, 10 Mar 2017 06:51:22 GMT

Hello John,

Considering, you have used given expression in Show Conditional under the Layout Tab of List box object:

It will hide the List Box if Sales is greater than 0 and/or Brand has maruthi value (if both if statements true or any one of two is true). List Box will be visible to end users if both the If statements are false (Sales is less than 0 and Brand has value other than maruthi).

Hope this makes sense.

Regards!

Rahul

Re: List

nagarjuna_kotha — Fri, 10 Mar 2017 06:57:07 GMT

If ur sales are Gretter than 0 and Brand is equal to Maruti, that object will be visible to you and rest of the conditions it will be in visible to you.

-Nagarjun

Re: List

smilingjohn — Fri, 10 Mar 2017 06:59:50 GMT

hi Rahul ,

Thanks for the reply .

In brand i have

maruthi,

TVS

Bajaj.

=IF(sales > 0, 0, 1)and IF(Brand='maruthi',0,1)

SO my requirement is that whenever i slect maruthi brand the list box should hide and for other brand it dhould show , so i have written the above expression .. it work work right ?

if TVS or Bajaj is selected in the brand this should display listbox.

Re: List

smilingjohn — Fri, 10 Mar 2017 07:00:45 GMT

Nagaraju when sales are greater than zero this shoul hide .

Re: List

rahulpawarb — Fri, 10 Mar 2017 07:24:41 GMT

John,

If Maruthi is selected and sales is greater than zero then below expression will hide the list box else it will show the list box for other brand values.

If(sales > 0 and Brand='maruthi', 0, 1) or If(Brand='TVS' or Brand='Bajaj', 1, 0)

Hope this will help.

Regards!

Rahul

Re: List

avinashelite — Fri, 10 Mar 2017 07:35:35 GMT

did you check the text format of maruthi ? whether its maruthi and a space ? or Maruthi ?

share the app that will be easier to help you

Re: List

Anonymous — Fri, 10 Mar 2017 08:13:08 GMT

Hi John,

As you mention in ur post,

=IF(sales > 0, 0, 1)and IF(Brand='maruthi',0,1)

if both the conditions,sales is greater den 0 and brand is Marathi,than result will be 0(Hide),otherwise

if any of one condition won't satisfy than result will be 1(show).

R/Murali.