Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikgurus,
i need to work out an expression but it's showing me null
my data is like this
col1- 24%
col2- 17%
col3- 19%
col4- 20%
AVG - 20%
this is how it looks in the straight table and now i want that avg vaule i.e 20 in my case as 3rd column like this
col1- 24% 20
col2- 17% 20
col3- 19% 20
col4- 20% 20
Total - 20% 20
for vaules 24, 17, 19 20 i'm using some set anaysis expression
how do write expression for getting that avg 20 vaules ..can somebody help me
Thanks
Have a great day
Are you looking for the expression total?
=(COUNT(total {<QUADRANT_WO_VF={'Bottom Left'}>}ADWEEK))/(COUNT(total (ADWEEK))-COUNT(total {<QUADRANT_WO_VF={""}>}ADWEEK))
I don´t know your filed names so I´m going to think up a field that contains your percentages, so you could use something like this:
sum(total Percentage) / 4
thanks jose for your reply..........
but in my case the fileds i'm using has different no of field vaues
in other words col1 to colN
in that case how to deal with this
do u want me to attach my sampe data
that would be helpfull, thanks
here my sample data
any suggestion pls
Are you looking for the expression total?
=(COUNT(total {<QUADRANT_WO_VF={'Bottom Left'}>}ADWEEK))/(COUNT(total (ADWEEK))-COUNT(total {<QUADRANT_WO_VF={""}>}ADWEEK))
I think the word "total" is your friend.
count(total FIELDNAME) makes sure that not the count per dimension is calculated but the total count...
Find the attached sample to see how I calculated the 31% column.
Hope it helps.
ps: apparently swuel was a bit quicker than me 🙂
thanks you guys seems like it's preety simple ..but i wasted 3 days on this this
really apperciate your help thanks
have a great day