Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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_id | P_id | V_id | Privacy_status |
C1 | p1 | v1 | public |
C1 | p1 | v2 | public |
C1 | p1 | v3 | public |
C1 | p2 | v45 | public |
C1 | p2 | v33 | private |
C1 | p2 | v32 | private |
C1 | p3 | v1 | private |
C1 | p3 | v11 | private |
C1 | p4 | v77 | public |
C1 | p5 | v22 | public |
C1 | p5 | v98 | private |
Result:
Result | ||
C_id | status | count(distinct P_id) |
C1 | public | 2 |
C1 | private | 1 |
C1 | mix | 2 |
see attach
Hi,
one front end solution might be:
hope this helps
regards
Marco
Thank you so much Marco. its solved my problem!!!