topic table box in QlikView

table box

manoranjan_d — Tue, 08 Nov 2016 11:51:12 GMT

hi all

in the table BOX i want to display the field FOR inactive user. how to do this in the table box and in the straight table?

example data

ID	USERNAME	LASTNAME	FIRSTNAME	NAME	ACTIVE_INACTIVE
1	A	XXX1	XXX1	AA1	ACTIVE
2	B	XXX2	XXX2	AA2	INACTIVE
3	C	XXX3	XXX3	AA3	ACTIVE
4	A	XXX4	XXX4	AA4	INACTIVE
5	B	XXX5	XXX5	AA5	ACTIVE
6	C	XXX6	XXX6	AA6	INACTIVE
7	A	XXX7	XXX7	AA7	ACTIVE
8	B	XXX8	XXX8	AA8	INACTIVE
9	C	XXX9	XXX9	AA9	ACTIVE
10	A	XXX10	XXX10	AA10	INACTIVE
11	B	XXX11	XXX11	AA11	ACTIVE

USE

Re: table box

sunny_talwar — Tue, 08 Nov 2016 11:54:30 GMT

field FOR? I don't see any column with header FOR? Can you elaborate on your requirement?

Re: table box

manoranjan_d — Tue, 08 Nov 2016 11:57:21 GMT

its just for, typo error i need all the all fields to be displayed only for inactive

Re: table box

manoranjan_d — Tue, 08 Nov 2016 12:15:00 GMT

sunny careply me waitig for your reply

Re: table box

hemanthaanichet — Tue, 08 Nov 2016 12:16:03 GMT

Hi Mano

in Straight table we can achieve it like below

only(ACTIVE_INACTIVE= 'INACTIVE')

In Table Box we can achieve it like below

Sample:

LOAD ID,

UN,

LN,

FN,

Act_Inact

FROM

(ooxml, embedded labels, table is Sheet1)

where Act_Inact = 'INACTIVE';

Regards

hemanth

Re: table box

manoranjan_d — Tue, 08 Nov 2016 12:29:02 GMT

where we have to give this condition ?

Re: table box

hemanthaanichet — Tue, 08 Nov 2016 12:45:47 GMT

Hi Mano,

Attached the qvw for your reference

Regards,

Hemanth

Re: table box

manoranjan_d — Tue, 08 Nov 2016 12:55:17 GMT

no while i loading in the script i need all the details but while displaing in the front end i need only the inactive user details

Re: table box

hemanthaanichet — Tue, 08 Nov 2016 13:00:10 GMT

Hi Mano,

what you are asking is not possible with table box. It can be achieve through straight table

attached qvw will give what your thought of requirement.

Regards

Hemanth

Re: table box

its_anandrjs — Tue, 08 Nov 2016 14:49:59 GMT

You can use the Trigger for this

Sheet Event Trigger to be used for the selection of the Inactive Users

Regards

Anand