topic Re: report wise List Box Filters in QlikView

report wise List Box Filters

vinod2086 — Mon, 11 May 2015 08:03:31 GMT

Hello

i have created one report in that report am using 2 sheets. for example i hv created status report i have used two sheets one is for closed and one is for pending status report.

am using straight table i have applied condition it displaying separately that's fine. but when i select the list box by default it displaying all values here i don't want to display for closed report status list box should display only closed, closed by l1 and so on..

same as pending report

STATUS
closed
closed by l1
closed by l2
closed by l3
closed by l4
pending
pending from L1
pending from L2

is it possible.?

Thanks in advance.

Re: report wise List Box Filters

mrossoit — Mon, 11 May 2015 08:17:29 GMT

Hi,

I'm not sure to understand what you really want.

Have you tried to cycle report's page on closed by field?

If page 1 shows straight table containing closed status' records, you could go to Page's settings -> Union and cycle by "closed by" field.

Same for page 2 (that I suppose contains straight table showing pending status' records).

As alternative, upload your qvw so the problem will be clearer, please.

Regards

Re: report wise List Box Filters

sunilkumarqv — Mon, 11 May 2015 08:20:42 GMT

in listbox expression

=If(status,wildmatch(status,'closed*'))

then it gives only closed related fields in listbox

same way you can create pending listbox if you want

=If(status,wildmatch(status,'pending*'))

Re: report wise List Box Filters

vinod2086 — Mon, 11 May 2015 09:19:20 GMT

Hi Sunil,

i have tried above expression but list box displaying all values.

Re: report wise List Box Filters

sunilkumarqv — Mon, 11 May 2015 09:22:51 GMT

sorry for the prev one

this is the write one

Check the attach

its working for me ..

=If(WildMatch(Status,'closed*'),Status)

Re: report wise List Box Filters

vinod2086 — Mon, 11 May 2015 09:50:37 GMT

sorry sunil still am getting all data...

Re: report wise List Box Filters

sunilkumarqv — Mon, 11 May 2015 10:04:58 GMT

can use share sample data

Re: report wise List Box Filters

vinod2086 — Mon, 11 May 2015 10:18:21 GMT

hi sunil pls find attached app !

Re: report wise List Box Filters

jagan — Mon, 11 May 2015 10:23:24 GMT

Hi,

Try like this

LOAD

If(WildMatch(Status, '*closed*'), Status) AS ClosedStatus

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Re: report wise List Box Filters

sunilkumarqv — Mon, 11 May 2015 10:33:00 GMT

I didnt see any app

Re: report wise List Box Filters

awhitfield — Mon, 11 May 2015 10:37:57 GMT

HI Vinod,

see the attached as per Sunil

Andy

Re: report wise List Box Filters

vinod2086 — Mon, 11 May 2015 11:25:31 GMT

Hi Andrew,

script level its okay i know that.

i don't want like this i want only front end.

i want to apply condition on list box only(instead of creating new list box )

i want to use same list box in multiple purpose in different charts

is there any possible way ?

Re: report wise List Box Filters

awhitfield — Mon, 11 May 2015 11:42:24 GMT

In the example it is done in the front end, using an expression instead of a field on the general tab:

Re: report wise List Box Filters

vinod2086 — Mon, 11 May 2015 12:09:26 GMT

yes this is what.

Thank you so much andrew.

i had tried same condition in expressions tab that is what am not getting expected output.

Re: report wise List Box Filters

sunilkumarqv — Mon, 11 May 2015 13:02:56 GMT

Hi vinod

u probably not see list box expression which posted earlier