Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
noviceneil
Partner - Contributor III
Partner - 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 @noviceneil 

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

MayilVahanan_0-1618742373157.png

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
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