Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Bar chart creation using particular fields from 2 dimensions

Hi All,

I am facing a challenge to create a bar chart using 2 dimensions for below data set.

   

ManagerSupervisiorPAT Roll No
AnindyaABC1
AnindyaABC11
AnindyaABC22
AnindyaABC1
AnindyaABC22
AnindyaABC33
AnindyaDEF10
AnindyaDEF10
MehtabABC33
MehtabFED44
SagarABC22
SagarFED33

I need to create bar chart only for Anindya and sagar who are under manager and for supervisiors ABC,FED and bar chart should be 'grouped bar chart' and it should show share of count of  DISTINCT 'PAT Roll No' under supervisior and manager dimension in respective bars. for example count of PAT roll no in Anindya in ABC and FED is 4(as there is no FED for anindya) so ABC bar chart will show 100%(4/4) and for FED it will be 0%

Then for sagar count of pat roll no under ABC and FED is 2(1+1) so 50% for ABC bar(1/2) and 50% for FED bar(1/2)


Note - need to count distinct PAT roll no under Manager and supervisior combination but PAT Roll no can be duplicate among different combinations

Thanks,

3 Replies
Highlighted

Highlighted

Highlighted
Contributor III
Contributor III

Anindya,


309204:
LOAD * Inline [

Manager, Supervisior, "PAT Roll No"
Anindya, ABC, 1
Anindya, ABC, 11
Anindya, ABC, 22
Anindya, ABC, 1
Anindya, ABC, 22
Anindya, ABC, 33
Anindya, DEF, 10
Anindya, DEF, 10
Mehtab, ABC, 33
Mehtab, FED, 44
Sagar, ABC, 22
Sagar, FED, 33
]
(delimiter is ',');



Create a bar chart:

Dimension: =aggr(only({1<Manager={'Anindya','Sagar'}>} Manager),Manager)

create two expressions

ABC%Expression:==count({<Supervisior={'ABC'}>}DISTINCT [PAT Roll No])/count({<Supervisior={'ABC','FED'}>}DISTINCT [PAT Roll No])

FED% Expression: =count(AGGR(count({<Supervisior={'FED'}>}DISTINCT [PAT Roll No]),Manager))/count({<Supervisior={'ABC','FED'}>}DISTINCT [PAT Roll No])

Style : Select Stacked

Presentation: check Plot Values inside segments

Dimensions tab: check suppress null values.