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: 
Anonymous
Not applicable

Pivot Table keeping value constant, when user enters value

Hi,

Please see attachment; before reading:

I basically have this, now when the user selects Company A, I do no want anything to change in the below table i.e If the user selects

a Company then I want to see

A    -----  50 (I do not want this to change to 100, I want is to remain 50 even though the user selected a Company).

I understand why this happens with the current logic that I am using in the expression i.e.

count(Transactions)/count(Total Transactions).

I have tried to use count(Transactions)/count(All Transactions), but I do not want all the Transactions for eg. April's Data.

Any Help will appreciated. 

Kind Regards

Razak

Capture.PNG

1 Solution

Accepted Solutions
Nicole-Smith

See attached.

I hope this helps!

View solution in original post

1 Reply
Nicole-Smith

See attached.

I hope this helps!