Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pawwy1415
Contributor II

Bar chart help

Hi Experts,

Can any one please help me on below requirement.

I have below Bar chart with

Dimension=[Reporting Month]

1 Measures used like below

=Count({<[Hiring Month]={'$(=Max([Reporting Month]))'},Status={'Active'},[Reporting Month]=>}distinct ID)

Requirement is in the below bar chart i have to show all the Months i.e.Feb 2018,Mar 2018 and Apr 2018 and need to show count(distinct ID) where Hiring Month=Reporting Month.

Expected output

Feb 2018=2

Mar 2018=2

and Apr 2018=4

requirement.png

1 Solution

Accepted Solutions
jyothish8807
Honored Contributor II

Re: Bar chart help

Hi Kumar,

Try like this:

Dimension=[Reporting Month]

2 Measures used like below

1. Joiners =Count({<[Status]={'Active'}>}distinct [ID])

2. Leavers =Count({<[Status]={'Left'}>}distinct [ID])

if you want the charts independent of selection on "[Reporting Month]", then try like this:


Dimension=[Reporting Month]

2 Measures used like below

1. Joiners =Count({<[Status]={'Active'},[Reporting Month]=>}distinct [ID])

2. Leavers =Count({<[Status]={'Left'},[Reporting Month]=>}distinct [ID])

Br,

KC

Best Regards,
KC
3 Replies
jyothish8807
Honored Contributor II

Re: Bar chart help

Hi Kumar,

Try like this:

Dimension=[Reporting Month]

2 Measures used like below

1. Joiners =Count({<[Status]={'Active'}>}distinct [ID])

2. Leavers =Count({<[Status]={'Left'}>}distinct [ID])

if you want the charts independent of selection on "[Reporting Month]", then try like this:


Dimension=[Reporting Month]

2 Measures used like below

1. Joiners =Count({<[Status]={'Active'},[Reporting Month]=>}distinct [ID])

2. Leavers =Count({<[Status]={'Left'},[Reporting Month]=>}distinct [ID])

Br,

KC

Best Regards,
KC
MVP
MVP

Re: Bar chart help

The whole thread just vanished in the wind.... good job pawwy1415‌‌ for making sure that all our efforts go in vain

pawwy1415
Contributor II

Re: Bar chart help

Hi Sunny,

Please don't mind. I have shared some real time screen shots. I have tried to remove my reply but unfortunately the whole reply's were gone.