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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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. 🙂