Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
subash
Partner
Partner

Filter the row value based on the selection in qliksense

Hi all,

i want to filter the rows based on the selection like i have one table chart which is having 2 columns A and B in and another one is filter pane which is having 3 values red, yellow and Green so what my requirement is if i select red then it should show only negative values rows and hides rest of all but both the table doesn't have any relationship 

i have attached screenshot for your reference.

so can anyone help me to sort out this one...


Capture12.PNG

 

Labels (1)
1 Solution

Accepted Solutions
y_grynechko
Creator III
Creator III

Hey,

Load script:

Date:
load * inline [
Label, Value
A1, -10
B1, 0
C1, 10
];

DateWithColor:
Load
Label,
Value,
if(Value = 0, 'Yellow',
if(Value < 0, 'Red',
'Green')) as Color
Resident Date;

Drop Table Date;

 

Result:

Capture.PNG

View solution in original post

1 Reply
y_grynechko
Creator III
Creator III

Hey,

Load script:

Date:
load * inline [
Label, Value
A1, -10
B1, 0
C1, 10
];

DateWithColor:
Load
Label,
Value,
if(Value = 0, 'Yellow',
if(Value < 0, 'Red',
'Green')) as Color
Resident Date;

Drop Table Date;

 

Result:

Capture.PNG

View solution in original post