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
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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: 
dandaanilreddy
Partner - Creator III
Partner - Creator III
‎2017-10-10 08:33 AM

9 quarters excluding nulls

Hello Experts,

I have a calculated dimension as if(quarter = 'Q',null(),quarter). Which is displaying 11 quarters from 2017Q2 to 2019Q4. I want to display only first 10 quarters like 2017Q2  as P0 to P9 ie 2019 Q4. I tried with using agg function but its not returning any quarters. Can someone help me ?

Labels (1)
Labels
575 Views
0 Likes
1 Reply
jonathandienst
Partner - Champion III
Partner - Champion III
‎2017-10-10 08:43 AM

I'm sure someone can help you, but its nearly impossible to do so on the limited information you have provided.

Qlik Community Tip: How to Get Answers to Your Post

Qlik Community Tip: Posting Successful Discussion Threads

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
538 Views