Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a requirement to convert a Bar chart from Qlik view to Sense.
The below are the measures being used in Qlik view.
There are 4 measures being used in Qlik view, Out of 4 measure only for 3 measures the bars are being displayed. The Last measure i.e Rank is shown on Y- Axis along with dimension with out the bars.
Could anyone please let me how can I achieve the same in Qlik Sense?
Thanks,
S K
See if this link helps
hi,
try to use line bar combo. in qliksense there is a option called marker u can choose that option instead of bar.
(i.e: for the 3 measure set type as bar and last one measure set type as marker).
Hi Devarasu,
By Using the Combo chart the orientation is not possible.
I need the bars to be displayed horizontally.
Thanks,
S K
Maybe use a simple bar chart:
put ur 3 measures
and as ur dimension:
YourDimension&' : '& aggr(rank(YourDimension,YourMeasure),YourDimension)
per analogy, sthing like this:
=[OICA region]&': rank by car production:'& aggr(rank([OICA region],[Car production]),[OICA region])
result:
and if u want to color ur measures as u want, create the measures as master item and affet colors to them:
result:
Hi Omar,
Thanks for your reply.
I am using Drill down as my Dimension. Will the above logic works drill down as well.
Thanks,
SK
Hi,
The below are the three Dimesions which I am using in Drill Down.
Dim1: =if([field1]<>'text',[field1])
Dim2: = if(field2<>'text2',field2)
Dim3 : field3
Thanks,
S K
Please try to adapt this logic to ur case:
I mean if u have a drill down dimension composed of dim1 and dim2
-u are in dim1 when u do not select a value in dim1
=> if u select a value from dim1, u're in dim2
so; ur dimension would be sthing like:
dim 1 :
=dim1&
aggr(if( count(distinct dim1)<>1,
' rank is '& aggr(rank(dim1,yourMeasure),dim1),''),dim1)
dim2:
=dim2&
aggr(if( count(distinct dim1)=1,
' rank is '& aggr(rank(dim2,yourMeasure),dim2),''),dim2)
per analogy:
Please, don't forget to mark as helpful the answers that has been helpful to u, and correct the correct answer
Hi Omar,
I have tried this but the output is not as expected.
Is there any other way to do this.
Thanks
S K