Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amit_saini
Master III
Master 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
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

15 Replies
Not applicable

Hi,

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

amit_saini
Master III
Master III
Author

Any help ????

amit_saini
Master III
Master III
Author

Not working!

jagan
Luminary Alumni
Luminary Alumni

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
Creator III
Creator III

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
Master III
Master III
Author

Hi Jagan,

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

Kindly help if possible.

Thanks,

AS

mato32188
Specialist
Specialist

Hi amit,

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

ECG line chart is the most important visualization in your life.
jagan
Luminary Alumni
Luminary Alumni

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
Master III
Master III
Author

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