Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
DRneel
Contributor III
Contributor III

how to create 2 tables from single table data visually

Hello,

           could someone help on the following,

I have a table ,

col1            col2         flag

11                  AA             1

12                   AB            0

13                   AC             1

14                   AD             0

The actual number of rows and columns 100+

I need to show 2 different views(table chart) in a single sheet,

Current:

col1            col2         flag

11                  AA             1

13                   AC             1

Previous:

col1            col2         flag

12                   AB            0

14                   AD             0

Please take into consideration, I don't want to create 2 separate tables in script due to other required views. is it possible to put a condition that will be applicable for the whole table.

2 Replies
MayilVahanan

HI @DRneel 

Might be, if you can use set condition to display the expression for both scenario

MayilVahanan_0-1618742373157.png

 

Thanks & Regards,
Mayil Vahanan R
andykrst
Contributor III
Contributor III

hii..

 

maybe you can make that flag col as an expression and use set analysis to fulfill this like. .

dimension : col1 , col2

expression : only({<flag={1}>}flag)

you need adjust the flag in expression in other table.

 

hope this help