Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
QS21
Creator
Creator
‎2023-11-09 06:08 AM

Numeric fields in a straight table without month

Hi All,

I have a table like this in excel:

COUNTRY LAST MTH Values1 CURR MTH Value2 VAR YTD  Value1 YTD Value2 YTD VAR YTD VAR %
India 20 30 -10 50 70 -20 -29%

 

inorder to replicate this in qliksense, I have created these fields in the qliksesense load script. however when I pull those in front end table, it is not showing values instead showing NULLs. When I add month column in to the same table it shows data but I cant show month show as few of the measures are YTDs where are other are for current month. Please help!

729 Views
0 Likes
1 Reply
sidhiq91
Specialist II
Specialist II
‎2023-12-02 11:16 PM

@QS21  Please share the data that you are loading to Qlik sense.

683 Views
0 Likes