Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Bar chart using calculation on different fields

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.

1 Reply
Highlighted

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