Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

stack Bar issue

Dear All,

I have below source and wanted to create a stacked Bar chart on below 3 Status values. I have given my required result also.  I have made it in database level using sub queries, but couldn't get in Qlikview. 

Thanks,

   

Source
C_idP_idV_idPrivacy_status
C1p1v1public
C1p1v2public
C1p1v3public
C1p2v45public
C1p2v33private
C1p2v32private
C1p3v1private
C1p3v11private
C1p4v77public
C1p5v22public
C1p5v98private

Result:

  

Result
C_idstatus                    count(distinct P_id)
C1public2
C1private1
C1mix2
1 Solution

Accepted Solutions
MarcoWedel

Hi,

one front end solution might be:

QlikCommunity_Thread_229721_Pic1.JPG

QlikCommunity_Thread_229721_Pic2.JPG

QlikCommunity_Thread_229721_Pic3.JPG

QlikCommunity_Thread_229721_Pic4.JPG

QlikCommunity_Thread_229721_Pic5.JPG

hope this helps

regards

Marco

View solution in original post

3 Replies
florentina_doga
Partner - Creator III
Partner - Creator III

see attach

MarcoWedel

Hi,

one front end solution might be:

QlikCommunity_Thread_229721_Pic1.JPG

QlikCommunity_Thread_229721_Pic2.JPG

QlikCommunity_Thread_229721_Pic3.JPG

QlikCommunity_Thread_229721_Pic4.JPG

QlikCommunity_Thread_229721_Pic5.JPG

hope this helps

regards

Marco

Not applicable
Author

Thank you so much Marco. its solved my problem!!!