Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
bobbydave
Creator III
Creator III

Show every 3rd value

Any ideas how I would show every 3rd value

I was thinking

IF (FieldValue(CANX_MONTH ,3), CANX_MONTH )

1 Solution

Accepted Solutions
sunny_talwar

May be this:

If(Mod(CANX_MONTH , 3) = 0, CANX_MONTH)

View solution in original post

2 Replies
sunny_talwar

May be this:

If(Mod(CANX_MONTH , 3) = 0, CANX_MONTH)

bobbydave
Creator III
Creator III
Author

Works a charm

Thanks