set Analysis fixing a value

[Anonymous]

Hi

I am looking for a piece of set analysis that will fix the value of a bar (blue bar) but vary the value of the second bar based on current selection (purple bar).

[sunny_talwar · Accepted solution]

May be like this:

Blue bar -> Sum({1} Measure)

Purple bar -> Sum(Measure)

[Anonymous]

Hi

I have tried your suggestion but I did not get the desired result. this is my code:

sum({1} {$(=vExpTotal)}  / sum(TOTAL [Number Of Trees]))

[sunny_talwar]

How do you define vExpTotal?

[Anonymous]

sum(1* 1* 1 / 1 / 1)

1 = measures

[sunny_talwar]

I don't really understand this, would you be able to share a sample?

[Anonymous]

I would like but it is highly confidential

[Anonymous]

the 1(s) represent measures that I'm multiplying & dividing

[sunny_talwar]

What is the point of multiplying and dividing the same thing multiple times?

So assuming 1 -> Sales

Sales*Sales*Sales/Sales/Sales = Sales, then why not just do Sum(Sales)?

[sunny_talwar]

May be mock up some data, because we will have trouble helping you with the kind of information we are looking at.

QlikCommunity Tip: How to get answers to your post?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

Best,

Sunny