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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Applicable88
Creator III
Creator III

How to transfrom a set expression to a dimension with string return instad of ONE and ZERO

Hello,

I have following expression:

count(if(num(floor([EntryDate]))<num(floor(Date(today()-30))) and isnull([DispatchDate]),OrderNO)

It works well as a measure, but not when I want instead of one and zero return as a Dimension:

=aggr(count(if(num(floor([EntryDate]))<num(floor(Date(today()-30))) and isnull([DispatchDate]),OrderNO)),OrderNO)

still get 1 and 0's . 

I also tried this:

if(count(if(num(floor([EntryDate]))<num(floor(Date(today()-30))) and isnull([DispatchDate]),PRONum))>0,'Yes','NO'))

I wan to instead return with 'Yes' and else 'No'

Any ideas?

Thanks a lot

Best. 

 

 

1 Solution

Accepted Solutions
tresB
Champion III
Champion III

@Applicable88 

You need to combine the two (that you tried separately). Try something like:

If (Aggr(Count(.......) ,..)>0, 'Yes', 'No')

View solution in original post

1 Reply
tresB
Champion III
Champion III

@Applicable88 

You need to combine the two (that you tried separately). Try something like:

If (Aggr(Count(.......) ,..)>0, 'Yes', 'No')