topic AW:selection screen to show only if data is in in QlikView

selection screen to show only if data is in

bumin — Tue, 11 Jan 2011 10:56:41 GMT

I want to show the selection screen only if there is data in it.

I tried to define the criteria within the layout folder but it didn't work.

see attached qv-object

Tue, 11 Jan 2011 11:59:46 GMT

I don't get your question. I looked at your qvd and...

What means "data in it".

Your layout restriction shows when something is selected in that field.

Tue, 11 Jan 2011 12:06:04 GMT

Try:

num(statmemo)<'10000' and cmpcode='D100'

in layout condition.

statmemo is no number by default I think. Don't if that is what you want to do!?

bumin — Tue, 11 Jan 2011 12:34:23 GMT

thanks Jonas

I'll explain with a simle list

I want to see the object "selection' only if there is a line in the inline-table with a missing statmemo field

So if you change the inline tbale like this

test:
REPLACE LOAD * INLINE [
cmpcode, code, statmemo
D100, '4580', ' '
D100, '8000', '30000'
C100, '4580', '25000'
C100, '8000', '30000'
];

The selecttion object should appear

If you have this situation

test:
REPLACE LOAD * INLINE [
cmpcode, code, statmemo
D100, '4580', '25000'
D100, '8000', '30000'
C100, '4580', '25000'
C100, '8000', '30000'
];

The selection object should not appear at all

Tue, 11 Jan 2011 13:12:17 GMT

sum(If(ISNUM(statmemo),0,1))>0

This should work here. Put it in layout-section

bumin — Tue, 11 Jan 2011 14:35:57 GMT

thanks Jonas, It works