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?
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).
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])
The below are the three Dimesions which I am using in Drill Down.
Dim2: = if(field2<>'text2',field2)
Dim3 : field3
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 :
aggr(if( count(distinct dim1)<>1,
' rank is '& aggr(rank(dim1,yourMeasure),dim1),''),dim1)
aggr(if( count(distinct dim1)=1,
' rank is '& aggr(rank(dim2,yourMeasure),dim2),''),dim2)
Please, don't forget to mark as helpful the answers that has been helpful to u, and correct the correct answer