can you help me in set analysis expression

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

Hi,

I want to find out the test availability

formula level1 %=(total available hours per month for level1 - sum(demo) / total available hours per month for level1

I have used expression:

if([Level]<>'Level 2',((24*Count(Month)*(193))-(sum([demo])))/(24*Count(Month)*(193)))

and to find out the Level2 formula

formula level2 %=(total available hours per month for level2 - sum(demo) / total available hours per month for level2

total available hours per month for level2 calculations

=16hrs

=31days(Month) - [Is Week End]<>1

=611 Applications

Note: Except Sundays only 6days in a week so I used a flag [Is Week End]<>1

if([Is Week End]<>1,((16*Count(Month)*(611))-(sum([demo])))/(16*Count(Month)*(611)))

So after using the above expression when I am selecting level 1 or level2 in separate check box my pivot table is not getting displayed and test tube chart is not getting displayed,

So can you kindly help me

Level	Demo
Level1	0
Level1	0.0333333
Level1	0.05
Level1	0.0666667
Level1	0.0833333
Level1	0.1
Level1	0.1166667
Level1	0.1333333
Level1	0.15
Level1	0.2333333
Level2	85.383333
Level2	85.633333
Level2	87.816667
Level2	88.583333
Level2	88.883333
Level2	89.433333
Level2	89.983333
Level2	93.05
Level2	94.833333
Level2	95.616667

Re: can you help me in set analysis expression

sunny_talwar — Fri, 15 Apr 2016 16:44:34 GMT

Can you share your qvw document?

topic can you help me in set analysis expression in QlikView

can you help me in set analysis expression

Re: can you help me in set analysis expression