Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

amit_saini
Honored Contributor III

Sicript help ????

Hi Folks,

I'm using Pivot table  and I'm looking for solution below:

if Average Demand  = „0“ and Actual Inventory Available = 0  and Actual Inventory Value= “0” then don’t show the Material number  in the report.

I'm trying something  like below , but not working

=IF( not isnull(ACTUAL_INV_VAL) and  not isnull(ACTUAL_INV_QTY)  and not isnull(AVG_DEMAND), Material_MATNR, NULL())

Thanks,

AS

1 Solution

Accepted Solutions
MVP
MVP

Re: Sicript help ????

Hi,

Don't use this in dimension, try the way I provided in my earlier post, if all the rows returns 0/null then the Material number automatically removed when you supress 0 and Null values in the Presentation tab.

Regards,

Jagan.

15 Replies
Not applicable

Re: Sicript help ????

Hi,

Try if(sum of all three <>0,field,0).

amit_saini
Honored Contributor III

Re: Sicript help ????

Any help ????

amit_saini
Honored Contributor III

Re: Sicript help ????

Not working!

MVP
MVP

Re: Sicript help ????

Hi,

You need to use this condtion in all the expressions

=IF( [Average Demand]  = 0 and [Actual Inventory Available] = 0  and [Actual Inventory Value= 0], Your Expression Goes here)


Note : If all expressions returns 0 in a row then that is automatically removed, to do this we are using above If().


Hope this helps you.


Regards,

Jagan.

qlikconsultant
Contributor II

Re: Sicript help ????

Also check the properties of you object:

Chart Properties -> Dimensions

- Suppress When Values is NULL should be marked

- Show All Values should be unmarked.

amit_saini
Honored Contributor III

Re: Sicript help ????

Hi Jagan,

Please see the attachment , I tried few things but still looks like approach is wrong.

Kindly help if possible.

Thanks,

AS

mato32188
Contributor III

Re: Sicript help ????

Hi amit,

try to use conditional show, but not sure, if it would fulfill your requirement.

MVP
MVP

Re: Sicript help ????

Hi Amit,

Please find attached file for solution, I implemented only for Currency column, do the same for remaining columns and check the presentation tab for changes.

Regards,

Jagan.

amit_saini
Honored Contributor III

Re: Sicript help ????

Hi Jagan,

Thanks for your response ,Just one question:

If(Column(1) >0 AND Column(2) > 0 AND Column(3) > 3,

CURRENCY, Null())

This Column(3) > 3 should be Column(3) > 0???


Thanks,

AS

Community Browser