topic Re: Input Box Doubt in QlikView

Input Box Doubt

rohitians — Mon, 01 Apr 2013 11:14:45 GMT

Hello,

I have a pie chart with cylclical drill (Product,City,Value) I am giving an input box to user to select suppose top 10 or 20.

But if the user does not selects any value in the input box the pie chart should consider all available values rather then 10 r 20...

Please help how can i do that ...

In dimension limit i took that variable Example vTop so if he select 10 so 10 is limit...

what do i do if user selects nthng i have to show all the values how do i do that...

Thanks and Regards

Rohit

Re: Input Box Doubt

Mon, 01 Apr 2013 11:19:14 GMT

Can you please upload an sample document

Re: Input Box Doubt

sushil353 — Mon, 01 Apr 2013 11:19:23 GMT

try to use if condition

if(variable=10 or variable=20,variable,30000)

HTH

Sushil

Re: Input Box Doubt

rohitians — Mon, 01 Apr 2013 11:31:43 GMT

Hey,

See in the dimension limit i am writing the variable name means if user chooses 10 den i show top 10 but he does not chooses anythng then i should show all the available values....

Thanks and Regards,

Rohit

Re: Input Box Doubt

rohitians — Mon, 01 Apr 2013 11:36:17 GMT

Hello,

If User Chooses 0 den then all 665 products should be displayed..

Is the expression right????

if(vTop=0,vTop,665)

Re: Input Box Doubt

sushil353 — Mon, 01 Apr 2013 11:46:22 GMT

try this:

if(variable=10 or variable=20,variable,if(vTop=0,665,665))

HTH

Sushil