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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist

Need to excludes values on date field

Hi!

Please check my loaded data of which month/year field takes value. How calculated dimension be applied to correct this as this goes as a dimension field!. Also appreciate if steps are properly laid down to correct through  number tab!

Thanks

Neville

      Excel used

BRANCHMONTH/YEAR MOTOR NON_MOTORTOT_PREMIUM
RAJanuary-16             100,000 250000               350,000
RAFebruary-16             250,000 300000               550,000
RAMarch-16             350,000 150000               500,000
RAApril-16             450,000 350000               800,000
RAMay-16             500,000 250000               750,000
RAJune-16             583,333 150000               733,333
RAJuly-16             658,333 200000               858,333
12 Replies
vishsaggi
Champion III
Champion III

NO problem. Just to correct you it is Vishwarath, so there is no N in my name.... 🙂

nevilledhamsiri
Specialist
Specialist
Author

Sorry, I will correct it!

Neville

vishsaggi
Champion III
Champion III

Oh you don't need to be sorry. That's cool just correcting. 🙂