Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
pavanqlik
Contributor II
Contributor II

Value list Issue

Hi Friends,

   I have a requirement where i need to show 10 KPIs with their values.For ex:

Tried creating Valuelist and created below table.

Most of the expressions are having multi aggregations.

MetricMeasure
KPI140
KPI224
KPI31.5
KPI499.45
KPI5123
KPI6154.33
KPI733
KPI81
KPI933
KPI10113.09

I am able to get the results properly with out any filtering.

My issue comes here:  If i filter any of the dimension from the dimensions list.


KPI4 has null value and other has values.  But my tables shows entirely null values.


MetricMeasure
KPI1-
KPI2-
KPI3-
KPI4-
KPI5-
KPI6-
KPI7-
KPI8-
KPI9-
KPI10-


Could you please let me know what might be the problem.

6 Replies
jafari_ervin
Creator III
Creator III

please attach your qvw file.

kamal_sanguri
Specialist
Specialist

use a set expression (if you have not already) and use modifier <Metric=,> inside your set expression.

qliksus
Specialist II
Specialist II

What's the expression you are using ?

pavanqlik
Contributor II
Contributor II
Author

HI,

I used that as well its not working.

Thanks,

Pavan

isingh30
Specialist
Specialist

Please share data or sample application.

Thank you!

VishalWaghole
Specialist II
Specialist II

Can you please attach sample application.