Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys,
I'm new in qlik sense, can anyone help me this one. Sorry if this has been answered before, I couldn't find the answer related.
I want show a stack bar graph with total workers by category, bar show full, and show in percent. Like this :
I try to create a company in one country with many braches on difference state. Total Branches in one State are diferrence, it based on which state we choose..
For example i choose State_A it will be like this:
and if i choose State_B it will be like this :
Graph will show based total branches in state which i selected. I tried using this extension, but it don't have stack bar graph.
GitHub - miclae76/trellis-chart: Qlik Sense Trellis Chart Extension
Can anybody help this one?
stalwar1 jpe mto vinieme12 reddys310
This is app that I tried to do : !
Try a dual expression
example
=DUAL(
'No of Workers:' & sum([TOTAL WORKERS]) & chr(10) &
'%of Workers:' & Num(sum([TOTAL WORKERS]) /sum(TOTAL <DEPARTMENT> [TOTAL WORKERS]),'##.0%')
,
sum([TOTAL WORKERS]) /sum(TOTAL <DEPARTMENT> [TOTAL WORKERS])
)
check this extension:
GitHub - brianbooden/StackedMultiples: Qlik Sense Stacked Multiples D3 extension
add a Dummy Dimension as below
DummyDIM:
LOAD RowNo() as DIM
AutoGenerate (2);
inChart
Use Calculated Dimension
=Pick(DIM,'TOTAL',DEPARTMENT)
Expression
sum([TOTAL WORKERS]) /sum(TOTAL <DEPARTMENT> [TOTAL WORKERS])
Hi vinieme12,
Thanks for your answer. I tried your solution and it show total, but almost what i wanted. Can you help me.
Here the result with your solution,
1) TOTAL not show as dimension that i used.
2) Why Count for bar chart not same with real one?
Your dimensions are not correct, just keep the below two
Dimension1: =Pick(DIM,'TOTAL',DEPARTMENT)
Dimension2: UNIT
<< You don't need pick() for UNIT dimension
Hi vinieme12,
Thank it works.. But i need you to help me to change a little..
Below is the result after i change dimension.
What I need :
1) When i hover at bar, Can i see in UNIT by percentage and TOTAL WORKERS? each bar show percentage and TOTAL WORKERS
Try a dual expression
example
=DUAL(
'No of Workers:' & sum([TOTAL WORKERS]) & chr(10) &
'%of Workers:' & Num(sum([TOTAL WORKERS]) /sum(TOTAL <DEPARTMENT> [TOTAL WORKERS]),'##.0%')
,
sum([TOTAL WORKERS]) /sum(TOTAL <DEPARTMENT> [TOTAL WORKERS])
)
your expression become like this one..
what i really want like this :
unitD : 21%
TOTAL WORKRES : 123
It show two detail in time. Can you help me to show like this?
Give a name to your measure
I don't work with Qlik Sense, but after reading other threads for custom popups in sense...this doesn't seem possible at the moment