This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a question about a KPI table. I want to use different KPIs (which are calculations in qlik editor) as a dimension for a KPI table. (see the appendix as an example).
However, I have no idea how to cast a calculation into a dimension so that, for example, I specify all calculations as a dimension under the name 'KPI'.
Someone any idea how this can be done? Thanks in advance!
Do sthing like this:
As a dimension in ur table use :
as a measure:
if( valuelist('Kpi1',Kpi2')='Kpi1', MeasureofKpi1,MeasureOfKpi2)
View solution in original post
Use the Simple KPI extension.
is it possible to convert that to a table?
It can be done with the ValueList() function as a dimension.
See Qlik help for a exsample
Use a table then. Any artificial dimension will be fine.
For the table.
Load a field (FAKE DIM) with values A, B, ……. N
Place that dimension in the dimension place.
Then go to measures and write:
IF([FAKE DIM]='A', first KPI,
IF([FAKE DIM]='B', secondKPI,
IF([FAKE DIM]='N', Nth KPI