topic Re: Function, number and set analysis in QlikView

Function, number and set analysis

Wed, 10 Dec 2014 10:06:19 GMT

I have a set analysis with some parameters and one of them affects the result to not give the correct answear.:

Class = {'=$(=Right(%Val_ChoiceClass,1))'}

If I change "Right(%Val_ChoiceClass,1)" to Class={6} I get the correct answer. How do I express that "Right(%Val_ChoiceClass,1) " to be a numeric value in the set expression

Thanks 🙂

Re: Function, number and set analysis

arulsettu — Wed, 10 Dec 2014 10:16:50 GMT

can you post your whole expression

Re: Function, number and set analysis

Wed, 10 Dec 2014 10:19:37 GMT

Try the following

Class = {$(=CONCAT(DISTINCT RIGHT(%Val_ChoiceClass,1),','))}

Re: Function, number and set analysis

rubenmarin — Wed, 10 Dec 2014 10:21:15 GMT

Hi you can create a Text Box with the expression "=Right(%Val_ChoiceClass,1)" and check if this really returns '6'.

If %Val_ChoiceClass should have a different value por row, it wouldn't work, set analisys is calculated for the whole table, not row by row, If this is the case you can use if(Right(%Val_ChoiceClass,1)='6', ....

Re: Function, number and set analysis

Wed, 10 Dec 2014 10:54:14 GMT

I've checked with a text box and I get 6 back 😞

I can post the hole expression later today when I get to my computer

Re: Function, number and set analysis

rubenmarin — Wed, 10 Dec 2014 10:59:06 GMT

So, the exact representation of Class={6} is:

Class={$(=Right(%Val_ChoiceClass,1))}

I think it should work like yours but you lost nothing to try.

Re: Function, number and set analysis

Thu, 11 Dec 2014 08:02:32 GMT

Sum({$<School={'Highschool'}, FLAG_defaultClass={1}, Class = {'=$(=Right(%Val_ChoiceClass,1))'}>}Grade*_Flag_Grade_Value)

If I change {'=$(=Right(%Val_ChoiceClass,1))'}>} to 6 i get the correct answer

Thank's for the suggestions

Re: Function, number and set analysis

Thu, 11 Dec 2014 11:20:47 GMT

Thank's Ruben that one worked