dimensions and measures

[louise119]

Why are dimensions and measures displayed differently when displaying data in a table?

If you want the data from the DB to be displayed in the dimensions, you will see the data, but
When displayed in measures, it becomes a hyphen.

Is there a way to avoid the hyphens?

[Lisa_Sun]

Hope this answers your question.

https://community.qlik.com/t5/App-Development/How-to-replace-the-dash-in-the-table-by-NA/td-p/190646...

If not, please share the sample qvf or screenshot.

[louise119]

thank you,

my question is why the result is change when I use dimensions or measures.

When I use dimensions to show data, I can see the data like below"Name".
But when I use measures, I can see just "-".

[Lisa_Sun]

Can you share the sample qvf?  

[RafaelBarrios]

Hi 

The first thing you should be clear about is the difference between dimensions and measures, a dimension groups data, while a measure is a calculation or an aggregation that must return a single possible value.

From your example, if you use Office as dimension and Name as measure, Qlik will try to show you a single value for Name, but having 3 values for dimension Office A, it doesn't know which one to show you and so it shows you hyphen.

so, in your case, you will need to use some text aggregation in order for this to work

concat(Name,',')

maxstring(Name)

minstring(Name)

only(Name)

count(Name)

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/StringA...

I hope this clears you up a bit.

best

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button!  😁