topic Re: Help in QlikView

Help

nagarjuna_kotha — Fri, 09 Oct 2015 11:28:45 GMT

HI I have an issue,

I attached one file to u.

In the i ahve one value in Text box,On the above i have one list box.If i select Hendred the should come in hundreds,if i select thousand ,the value should come in thousand.likewise.

Regards,

nagarjuna

Re: Help

pokassov — Fri, 09 Oct 2015 11:37:18 GMT

Hello!

Your text box is calculating sum(Sales).

Taking in mind that field "Sales" lies in the table "Data 2", which doesn't have any link with table Data where I see field ID, the behaviour is normal.

Re: Help

maxgro — Fri, 09 Oct 2015 11:39:53 GMT

=if(GetPossibleCount(ID)=1, Sum(Sales) / Val, sum(Sales))

Re: Help

miguelbraga — Fri, 09 Oct 2015 11:42:29 GMT

Please, refer to the attached QVW file. Hope you understand what I've done.

Miguel

Notes: Your Listbox need to be selected with Always One Selected to force only one option. Se the IF condition to know how I've done it in the TexBox!

Re: Help

NareshGuntur — Fri, 09 Oct 2015 13:11:38 GMT

Hi Nagarjuna,

Please use the below expression in text object and let me know if this is what you are expecting.

=Sum(Sales)/Only(Val)

Cheers,

Naresh

Re: Help

sudeepkm — Fri, 09 Oct 2015 13:46:46 GMT

Braga's solution would work very well. Just one thing to indicate that instead of if else you can simply use.

=sum(Sales)/Val

As he suggested you need to use Always one selected value so that there will always be a value in the denominator.