Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
kvijay173
Creator
Creator

How to create a dummy column?

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

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

4 Replies
sunny_talwar

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

buzzy996
Master II
Master II

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.

kvijay173
Creator
Creator
Author

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

sunny_talwar

Hahaha your most welcome.

Best,

Sunny