topic Re: Issue in QlikView

Issue

NavinReddy — Mon, 23 Sep 2013 04:39:16 GMT

Hi All,

i have two multiboxes with same name(Comp)

one multibox two levels

*.level1(Sublob)

*.level2(officer)

second multibox two levels

*.level1(sublob)

*.level2(Division)

Issue is

i have Soblob two fields banking ,commercial

if i select banking in lob Officer should appier

if i select Commercial in lob Division should appier

Help me some one issue

Thanks in Advance

Niru

Re: Issue

jagan — Mon, 23 Sep 2013 09:12:28 GMT

Hi,

Try creating a dynamic Dymension like this

If(Only(sublob) = 'banking', officer, Division)

Hope this helps you.

Regards,

Jagan.

Re: Issue

Mon, 23 Sep 2013 09:21:17 GMT

Sounds like a conditional statement is needed.

Add conditional [Sublob] = 'banking' to dimension/expression officer

And conditional [Sublob] = 'commercial' to dimension/expression division

Re: Issue

NavinReddy — Mon, 23 Sep 2013 09:23:58 GMT

Hi jagan,

but performance issue i never use if condition

Thanks

Niru

Re: Issue

Mon, 23 Sep 2013 09:27:53 GMT

Hi Niru

There is the above method. Or, if you are not attached to the multibox functionality wIthin the List Box Properties, on the 'Layout' tab there is a box where you can state a condition to hide/show a list box. So for the Officer list box you would you a formula such as;

Sublob = 'Banking'

But the above reply is best if you wish to keep the multiboxes.

All the best

Steve

Re: Issue

NavinReddy — Mon, 23 Sep 2013 09:48:40 GMT

I am not under standing ur logic

could you please send any attachment

Thanks

Niru

Re: Issue

NavinReddy — Mon, 23 Sep 2013 10:10:05 GMT

I atteched sample application

if select sub lob =business bank ,officer will appier

if select sub lob =commrcial ,vertical will apper

same multibox

some one help me

Thanks

Niru

Re: Issue

NavinReddy — Mon, 23 Sep 2013 11:01:11 GMT

Guys any idea....

Re: Re: Issue

Mon, 23 Sep 2013 11:04:01 GMT

You can break it down, but you'll have to use 3 multi-boxes.

Have a look at the attachment

Re: Issue

Mon, 23 Sep 2013 11:31:18 GMT

I would use Jagan's suggestion - yes IF's can use a lot of resources when using in a formula. However, that only really applies when using in a large straight/pivot table. This formula is not run multiple times over 1000's of rows, this is run once on one simple formula - it won't have a relevant impact on performance at all.

Re: Issue

NavinReddy — Mon, 23 Sep 2013 12:01:19 GMT

How can i use jagan expression in multibox

after that multibox i need to be put in container object

Thanks

Niru

Re: Issue

NavinReddy — Mon, 23 Sep 2013 12:57:53 GMT

inside container object how can i do this

help me

Re: Issue

NavinReddy — Tue, 24 Sep 2013 03:29:13 GMT

im facing same issue any help.

Re: Issue

NavinReddy — Tue, 24 Sep 2013 06:07:08 GMT

please find the attechment

if any idea .......

Re: Re: Issue

jagan — Tue, 24 Sep 2013 06:48:31 GMT

Hi Niru,

Please find attached file for solution.

Regards,

Jagan.