Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
arusanah
Creator II
Creator II

help with calculated dimension for SimpleKPI in qliksense

i am  using following expression to create value list  for simpleKPI in my app. But it says invalid dimension. I cannt replicate issue but it says invalid dimension

valueloop(1, count( distinct <Field Name>))

can anybody suggest what is error

5 Replies
jayaseelan
Creator III
Creator III

Hi,

   Please share the screen short for more clarity.

tresesco
MVP
MVP

Try like:

valueloop(1, $(=count( distinct <Field Name> FieldName2)))

arusanah
Creator II
Creator II
Author

what is <field Name 2>, I am loading dimensions dynamically

tresesco
MVP
MVP

In that case field2 would not be required. Just try like:  valueloop(1, $(=count( distinct YourField)))

simondachstr
Luminary Alumni
Luminary Alumni

Hey!

While you're at it, have a look at Vizlib's new supported KPI designer:

https://www.vizlib.com/kpi/

Keen to hear your thoughts!

Best,

Martin