Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikuser225
Contributor III
Contributor III

Conditional Selections

Hi All,

Can anyone please help we with below issue.

I have a data like

Category Fruit          Qtr       Weight     Fruit_Profit

Fruit         Apple   2024-Q1       10             Y

Fruit         Apple    2024-Q2      10             N

Fruit         Apple   2024-Q3        10            N

Fruit         Apple   2024-Q4        10            -

Fruit         Mango 2024-Q1       20             -

Fruit         Mango 2024-Q2        20             -

Fruit         Mango 2024-Q3        20            -

Fruit         Mango 2024-Q4        20            -

Fruit         Mango 2024-Q1       10             -

Fruit         Mango 2024-Q2        10             -

Fruit         Mango 2024-Q3        10            -

Fruit         Mango 2024-Q4        10            -

 

if i select 2024-Q1 where Fruit_Profit is 'Y'  i want to create a table with below results in front end

Fruit        Qtr      Weight

Apple   2024-Q1   10

Mango 2024-Q1    10 

 

if i select 2024-Q2 or 2024-Q3 where Fruit_Profit is 'N'  i want to show results in the same above table like

Fruit        Qtr      Weight

Apple   2024-Q2   10

Mango 2024-Q2    20 

 

Thanks, on Advance

 

 

2 Replies
Lisa_P
Employee
Employee

I don't understand your logic on the Fruit_Profit based on the data shown above

Qrishna
Master
Master

i dont see any records where Qtr=2024-Q1 and Fruit_Profit ='Y'  for Mango. and not sure why you got Weight =10 for Qtr=2024-Q1 and Fruit_Profit ='Y'  for Mango. please elaborate.