Bar chart using calculation on different fields

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

Hi All,

I am new to qlikview i want to create a bar chart using calculation on different fields(sum & division) but every time it shows the 100% of bar result . Below are the following expression and dimensions i have used.

Dimensions:- =valuelist('IP Address','Location','Name','Location')

expression:-

if (valuelist('FQDN','IP Address','Location','Name','Location','Serial Number')='IP Address',(sum(if(ip_address_complete=1,1,0))/sum(device_count)),
if (valuelist('FQDN','IP Address','Location','Name','Location','Serial Number')='Location',(sum(if(location_complete=1,1,0))/sum(device_count)),
if (valuelist('FQDN','IP Address','Location','Name','Location','Serial Number')='Name',(sum(if(name_complete=1,1,0))/sum(device_count)))))))

I have created some fields in scripts (ip_address_complete,location_complete,name_complete) but i need to take two time locations in Valuelist otherwise it shows error the No data to display.

Can anyone help me out in this.

Re: Bar chart using calculation on different fields

sunny_talwar — Fri, 26 Apr 2019 13:01:05 GMT

Would you be able to share a sample where we can see what you are doing?

topic Bar chart using calculation on different fields in QlikView

Bar chart using calculation on different fields

Re: Bar chart using calculation on different fields