topic Re: Static Bar in Bar chart in QlikView

Static Bar in Bar chart

Fri, 29 Nov 2013 16:45:55 GMT

Hi All,

I need your help, I want to use a bar chart and want to show few valuses for specific group, below is the details I am trying to do.

I am having a dimention called group, in this group we can have team and individual members. This group works on dofferent requests lets call it ticket. Now I want to show the count of tickets in Bar chart as below,

I want one statich bar which will show all the tickets handled by the group and we can have two filter conditions (list box) where I will have list of team and other will have least of team members. If I select a perticulat team if should show me all tickets handled (count of tickets) by group and all tickets handled by that perticular selected team OR if I select individual team member it should show me all tickets handled (count of tickets) by group and all tickets handled by that individual selected team member, so here in all case one BAR i.e. tickets handled by group will always be statick and will never change.

Can anyone please help me how can I do this?

Thanks in advance for your help.

Regards,

Abhishek

Re: Static Bar in Bar chart

Sat, 30 Nov 2013 03:05:35 GMT

Hi All,

Can anyone please help me with this?

Thanks,

Abhishek

Re: Static Bar in Bar chart

Anonymous — Sat, 30 Nov 2013 05:00:47 GMT

It sounds like there are many ways to handle this. Try looking into "Set Analysis", "Alternate States", "Grouped Dimensions", "If statements" or the "Aggregation Function".

Re: Static Bar in Bar chart

Sat, 30 Nov 2013 05:44:02 GMT

Hi Abhishek,

In a bar chart take dimension As Group ,

expression1 -> Count(tickets)

expression 2-> Count({$<Group>} tickets)

so first expression value remains as it is what ever the selection..

in second expression it will change according to selection in group..

I hope it helps..

Regards,

koti

Re: Static Bar in Bar chart

Anonymous — Sat, 30 Nov 2013 06:42:36 GMT

Below is what I think you are looking for. Set Analysis is used to keep group static by removing the person field from the selection.

Re: Static Bar in Bar chart

Sun, 01 Dec 2013 02:15:16 GMT

Hi Koti,

I tried the option you suggested but it not working as I said in my original request there are 3 different filters i.e. group, team and team member. so even after applying your suggestion in the first filter i.e. group level its showing first bar as total ticket and second bar as hotal tickets handled by group which is good but when I apply second selection along with first i.e. team selection then for total ticket bar its shwing total ticket of team but even here I want total ticket of group and same when I am applying 3rd criteria team member its showing total ticket of team member but it should be total ticket in group vs ticket handled by team member or team.

Hope I make sance, please let me know if you have any question.

Thanks,

Abhishek

Re: Static Bar in Bar chart

Sun, 01 Dec 2013 02:17:42 GMT

Hi Michael,

Thanks for reply, I tried the option you suggested but it not working as I said in my original request there are 3 different filters i.e. group, team and team member. so even after applying your suggestion in the first filter i.e. group level its showing first bar as total ticket and second bar as hotal tickets handled by group which is good but when I apply second selection along with first i.e. team selection then for total ticket bar its shwing total ticket of team but even here I want total ticket of group and same when I am applying 3rd criteria team member its showing total ticket of team member but it should be total ticket in group vs ticket handled by team member or team. so I want first bar i.e. total ticket by group to be static all the time and shouldnt change even if we are selecting team or team member filter.

Please let me know if you need further clarification.

Thanks,

Abhishek

Re: Static Bar in Bar chart

Mon, 02 Dec 2013 00:28:48 GMT

Hi,

Can anyone please help me with this?

Thanks,

Abhi

Re: Re: Static Bar in Bar chart

Anonymous — Mon, 02 Dec 2013 02:28:43 GMT

I am not sure if I understand you correctly but it seems like you want a chart that will have only 2 bars, first bar will show the total ticket count for all group and will be static all the time and second bar will show the filtered result according to your selections on Team and Team Member field.

Please see the attached sample, hope it helps.

Regards

Re: Re: Static Bar in Bar chart

Mon, 02 Dec 2013 02:57:16 GMT

Hi Chee Tiong Chua,

Thanks for the reply, yes this is what I am looking for. But when I am trying it with my data its not working. Below I provided my sample data.

I am using one dimention "Currently Assigned Group Name" and the expressions I am using are as below

Group Total : sum (total {<[Currently Assigned Group Name]=,Manager=,TicketOwner=>} [Ticket Number])

Ticket Count : = count(if([Ticket Status] = 'Closed', [Ticket Number]))

Currently Assigned Group Name	TicketOwner	Ticket Number	Manager	Ticket Status
abc.pqr	abhi	300-12696	David	Closed
abc.pqr	Raj	300-12697	David	Closed
xyz	roy	300-11872	Lori	Closed
Aup	abhi	300-12032	David	Queued
abc.pqr	mannu	300-12057	David	Closed
xyz	jim	300-12014	Lori	Pending
ppp	abhi	300-11470	roky	Closed
aaa	raj	300-8867	ash	Closed
abc.pqr	joy	300-9017	David	Closed
lpp	mannu	300-9018	Moly	Closed
aum	abhi	300-9254	David	Resolved

Thanks for your help.

Regards,

Abhishek

Re: Static Bar in Bar chart

Anonymous — Mon, 02 Dec 2013 03:14:29 GMT

Can you try changing 'Sum' to 'Count'?

Regards

Re: Static Bar in Bar chart

Mon, 02 Dec 2013 03:52:14 GMT

After using count its working, but its showing all the croups even if we select one i.e suppose if I select "abc.pqr" then we should see result only for "abc.pqr" but its showing all groups. As I am having many groups so the presentation is not up to the mark, can we anyhow just show the groups only which we select?

Thanks,

Abhishek

Re: Static Bar in Bar chart

Anonymous — Mon, 02 Dec 2013 05:01:59 GMT

Yes, you can just remove "[Currently Assigned Group Name]=" from you group total expression, what the set analysis in the expression does is simply just ignoring the selection made to the field.

Regards.