topic Re: set Analysis fixing a value in QlikView

set Analysis fixing a value

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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).

Re: set Analysis fixing a value

sunny_talwar — Fri, 30 Sep 2016 13:52:22 GMT

May be like this:

Blue bar -> Sum({1} Measure)

Purple bar -> Sum(Measure)

Re: set Analysis fixing a value

Anonymous — Fri, 30 Sep 2016 14:05:12 GMT

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]))

Re: set Analysis fixing a value

sunny_talwar — Fri, 30 Sep 2016 14:09:08 GMT

How do you define vExpTotal?

Re: set Analysis fixing a value

Anonymous — Fri, 30 Sep 2016 14:14:38 GMT

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

1 = measures

Re: set Analysis fixing a value

sunny_talwar — Fri, 30 Sep 2016 14:16:33 GMT

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

Re: set Analysis fixing a value

Anonymous — Fri, 30 Sep 2016 14:18:58 GMT

I would like but it is highly confidential

Re: set Analysis fixing a value

Anonymous — Fri, 30 Sep 2016 14:20:52 GMT

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

Re: set Analysis fixing a value

sunny_talwar — Fri, 30 Sep 2016 14:28:09 GMT

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)?

Re: set Analysis fixing a value

sunny_talwar — Fri, 30 Sep 2016 14:29:41 GMT

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