topic Re: Total Issue in QlikView

Total Issue

vipin_mishra479 — Thu, 09 Oct 2014 20:01:23 GMT

Hi All,

I have a four field F1 F1 F3 F4 where F1 F2 F3 are dimension and F4 are measure and my data is like this

F1 F2 F3 F4

here i get 22 avg but i want avg only compset (F2) data

like this

How can i get this please help and here i attached my application

antoniotiman — Thu, 09 Oct 2014 20:12:38 GMT

Hi Vipin,

Try

Avg({<F2={'ComSet'}>} F4)

Regards,

Antonio

vipin_mishra479 — Thu, 09 Oct 2014 20:14:50 GMT

if i use this i loss Property value

antoniotiman — Thu, 09 Oct 2014 20:37:40 GMT

vipin_mishra479 — Thu, 09 Oct 2014 20:46:24 GMT

Thanks Buddy....

maxgro — Thu, 09 Oct 2014 20:54:40 GMT

if(Dimensionality()=0, Avg({<F2={'ComSet'}>} F4), avg(F4))