Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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.
joshrussin
Contributor II

Graph help

Hey everyone,

Having some issues with this graph. I can get it filtered all the way except when I try to filter by client_CD. If anyone has any comments or help, please let me know. I'm probably overthinking this one, but just can't figure it out. I am trying to get the total of Client complaints from Jan, 2016 from Biomet in a bar graph.

Graph under QI graphs.

1 Solution

Accepted Solutions

Re: Graph help

Just responded in your other post, but the issue is extra space after the word Biomet

Count({$< Year_CD = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays)))-1)"},

Division_of_Occurance_CD = {'Olive Branch'}, Type_CD = {'CAPA-AF', 'CAPA-CAPA', 'CAPA-COM', 'CAPA-NMR'}, Client_CD = {'Biomet '}>} Num_CD)

1 Reply

Re: Graph help

Just responded in your other post, but the issue is extra space after the word Biomet

Count({$< Year_CD = {"$(=Year(FirstWorkDate(ConvertToLocalTime(Date(now()), 'GMT-05:00'),1,$(vHolidays)))-1)"},

Division_of_Occurance_CD = {'Olive Branch'}, Type_CD = {'CAPA-AF', 'CAPA-CAPA', 'CAPA-COM', 'CAPA-NMR'}, Client_CD = {'Biomet '}>} Num_CD)

Community Browser