topic Re: How to create a dummy column? in QlikView

How to create a dummy column?

Anonymous — Thu, 14 May 2015 11:58:59 GMT

I have 2 tables.

Table A with Columns Server, Status and Type

Table B with Columns Server, Status and Type

I success fully connected to DB and created a straight table object with these 3 columns. Data is displaying correctly.

Now If I want to see the data only from Table A - How to create a selection criteria. I need a button so that I can Select between Table A and Table B so that I could see the Straight Table object with appropriate table data as required.

Any ideas please

Re: How to create a dummy column?

sunny_talwar — Thu, 14 May 2015 12:08:37 GMT

You can create flags for this:

[Table A]:

LOAD [Columns Server],

Status,

Type,

'A' as TableFlag

From [Source A];

[Table B]:

LOAD [Columns Server],

Status,

Type,

B as TableFlag

From [Source B];

and then use TableFlag to choose between the two tables.

HTH

Best,

Sunny

Re: How to create a dummy column?

buzzy996 — Thu, 14 May 2015 12:14:54 GMT

just create a flag on ur table script like Sunny said above and use the same flag from front end selections to see corresponding table data.

Re: How to create a dummy column?

Anonymous — Thu, 14 May 2015 12:25:44 GMT

No words to appreciate you. Working like a feather. Thanks a ton.

Re: How to create a dummy column?

sunny_talwar — Thu, 14 May 2015 12:26:42 GMT

Hahaha your most welcome.

Best,

Sunny