Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Sunkanx
Contributor
Contributor

String field not properly shown in table

Hello. I have a problem when creating table in Qlik Sense. 

I have a database based on month and year in MM.YYYY format, where i calculate values for Current month - Previous month and add Comments to the table. Everything works great until i add comments or date to the table. Comments are sometimes Null and other times a string. Current Month and Year "08.2020" is selected as filter:

This is how it should be shown: comment1.png

But when i add field Date or Comment to the table it is shown like this:

comment2.pngcomment3.png

Does anyone have any idea how to solve this?

Thank you and Best regards

Labels (4)
1 Reply
MohasinKhan
Contributor III
Contributor III

Hi SunKanx,

Have you tried use the before / above function?

Probably, create a simple pivot table, add months in columns so you can show month over month trend.

Formula could be: I will give a name to column of your calculate values as 'Cost'.

Above( sum(Cost))

or

before (sum(Cost))

The first month will show blank, as it does not have any data to compare with, but then you should get the idea.

About the comments, I am not sure 😞