Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Slight Help

Hello all,

I need some help.

As you can see in attached file, I have some chart and I dont know what to do.

As you can see, there are multiple locations that I use as a dimension, to get the size of application that each location uses.

On the bottom are application, that are not used still, and I want to show how much each location is using space without the bottom -.

I cannot suppress the values, because it will only remove the info from the chart.

I am using the variable to sum everything, and then I divide the size of Qvw in MB with it.

1 Reply
Employee
Employee

Re: Slight Help

You can check the dimension for NULL values with the ISNULL function.   IE:   isnull(Location)<>-1   checks for only non-null values. Use it in the numerator and denonomitor to get a share that excludes the applications without a location

Community Browser