Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

supress rows in UI

Hi All,

I have 2 tables brought into one table by concatenation.
My requirement is to only see products that are present in first table(sales table) in my front end straight table. So that means i don't want to see below products in straight table.

K
M

 

 

Script-->

Sales:
LOAD * INLINE [
Product, Sales
A, 120
A, 10
B, 140
B, 15
C, 100
];

Concatenate(Sales)
//Budget:
LOAD * INLINE [
Product, Budget
A, 150
K, 180
M, 50
];

output-

Capture.JPG

 

Please help.

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Then use this: If(sum(Sales) > 0,sum(Budget))

View solution in original post

8 Replies
Highlighted
Partner
Partner

Hi,

Try to use left join statement instead of concatenate statement with the purpose of don't have the budget data that don't have sales.

I hope this solve your issue.

Dan.
Highlighted
Contributor III
Contributor III

Thanks for your reply.

My original tables have multiple columns and doing left join will effect the rows in sales table. So i want control this only in front end.

Highlighted
Partner
Partner

Your problem is the concatenate statment because if you ase ussing this your data isn't related. Attached the resultant table (Data with concatenate).

Data with concatenate.png

 

 

 

 

 

 

If you use the outer join function instead your data looks like (Data with outer join)

Data with outer join.png

 

 

 

 

and then you can use this expresion to sum only the budget that are sales > 0:

sum({<Budget={"=sum(Sales)>0"}>} Budget)

The final table looks like

Screenshot_1.png

 

 

Regards.

Dan.

Highlighted
Contributor III
Contributor III

Thanks for detailed explanation and your time. I understand you are suggesting me to do outer join. i am trying to avoid joins at the moment as there is lot going based on the final table in the live application.

I prefer doing it in front end. Is it possible to use Aggr() ? So our requirement is to show only those budget numbers that has sales.

 

 

 

Highlighted
Partner
Partner

Then use this: If(sum(Sales) > 0,sum(Budget))

View solution in original post

Highlighted
Creator III
Creator III

You can try an approach with some set analysis, check the attached for further details

 

Capture.PNG

 

 

Father/Husband/BI Developer
Highlighted
Partner
Partner

Try With Calculated Dimension
Calculated Dimension - =if(aggr(sum(Sales),Product)>0,Product)
And Suppress values when value is NUll.
Thanks
Raman
Highlighted
Contributor III
Contributor III

Thank you so much