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!
