Hi,
As i'm new to qlikview, i would want to know how to achieve the below scenario in QlikView.
I have a file with 5 columns namely ID, Name, Gender, Year and Promotion, See the attached file
Now in the chart i need to display the count of ID's both Genderwise and Promotionwise per year. Please note that Gender has two values M and F while Promotion has Y and N respectively. To be precise i need to get the count of both male and female ID's for each year, at the same time i need to get the count of the ID's who have got promotion.
I used the below code in the CHART expression :
=count(distinct if( Gender='M', ID) ) >>>>> for Gender
=count(distinct if( Promotion='Y' , ID) ) >>>> for Promotion
I have used the COMBO chart for the same, where Gender is represented in Bar while Promotion Count in Line. But the problem is that, I'm getting the total count(both male and female) for each year instead of the data appearing to be in a stacked format. ( See the snapshot below)
For Eg: If I have 5 records for the year 2010 out of which 3 are M(Male) while the rest are F. In this case while representing in chart, i need to get the data in a stacked format which differentiates the count between male and female for each year respectively.
Can you please assist me ?
Regards,
surman
.png "Luminary Alumni"){kind=icon}
