Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Expressions within set analysis and use of expressions outside straight table

Hi All

I have two fields like below

Account, qty

A,100

B,200

,200

C, 500

Along with it I have a field whose value is input by user - Sales

I have an expression field - Sales*sum(Qty)/sum(total(qty))

If the value of expression is less than a threshold and the account field is blank , I would like to delete that row and calculate the expression again.

 

Let me know how this can be done using set analysis or any other method.

 

Labels (2)
2 Replies
Highlighted
Specialist
Specialist

Hi,

The following might work.

You can try an expression that you hide that returns 1/0 for show/hide row;

20200528_1.png

Then use dimension limits to only return 1's and not show Others;

20200528_2.png

Cheers,

Chris.

Highlighted
Contributor
Contributor

Hey,

 

Deletion of row will work. However, I am more confused about how to recalculate my expression