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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Extract values depending on periods condition

Hello,

in attached sample file I would create a new list box element containing those combinations of AGENTE and CLIENTE pairs that don't have Periods value in its PERIODO_0 field.

For instance, about first pair "1, 100076" I would like to see as a final result:

1     100076     2011-01

1     100076     2011-04

1     100076     2011-08

1     100076     2011-10

1     100076     2011-11

1     100076     2011-12

1     100076     2012-02

1     100076     2012-07

1     100076     2012-08

...

Thank you in advance and best regards.

--

Marco Pikiri

Labels (1)
10 Replies
Not applicable
Author

Ok, this helps me to understand that if I temporarily disable your expression and if I add another one like:

If(1=0,1,0)

then all rows always are hidden due to 0 value always returned. Before your explanation I was convinced that with this kind of expression all rows should continue to appear with always a value of 0 aside. In fact, if the expression modifies to the opposite:

If(1=0,0,1)

or:

If(1=1,1,0)

now all rows return visible because in this case 1 value always returned (i.e. a value different from '0'). Is this correct?

Best regards.

--

Marco Pikiri