Skip to main content

Qlik

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
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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: 
qlikviewrmw
Contributor II
Contributor II
‎2018-11-02 07:08 AM

Determine which expression column number has a particular value

Good day

I am trying to determine from a PivotTable which expression has a particular value associated with it.

What I am wanting is to find out which column in the expressions has a ZERO value. The first occurence of the ZERO.

And then display this in my dimension. My expression totals are based on year and week so trying to figure out which year and week has the first occurence of a ZERO.

Is this even possible?

Thank you in advance

2,034 Views
0 Likes
20 Replies
sunny_talwar
MVP
MVP
‎2018-11-05 09:10 AM

In response to qlikviewrmw

It can be done within QlikView before QV12 as well, but you will have to sort your data in the correct order in the script. Right now it seems that Year and Week may not be sorted in the script in the ascending order. If you are able to sort them, then the issue should be resolved.

125 Views
0 Likes