topic Re: hi QlikView users in QlikView

hi QlikView users

Mon, 26 Jan 2026 18:19:17 GMT

Im beginner on QlikView.

So I'd like to ask a question, and it could be so easy to you.

want your understanding!:)

And! now, I wanna make a simple file about calculation.

There are three fields in a table.

field1 field2 field3

1 3 4

2 2 6

3 1 3

that's excel file.

and I will make a field4 using expression.

(field1+field2)*field3 ==> its just sample.

Q1. Can I select each value without association?

After selecting "1", I want make a check list among 3,2,1

but now I should accept number 3(field2), 4(field4) without select.

I won't compose three tables each other...

I want make a multibox without association.

its possible?

I hope you are exactly understanding my question ;(

thankyou.

Re: hi QlikView users

Thu, 14 Nov 2013 08:44:27 GMT

Hi,

If your 3 fields share the same dimensionnality, you will get the association.

If you do not want the association, remove the common dimensionnality (load these 3 fields into 3 tables for example but without any common field)

Fabrice

Re: hi QlikView users

israrkhan — Thu, 14 Nov 2013 08:45:33 GMT

load them in to qlikview like below:

load

field1,

field2 ,

field3,

field1 + field3 as field4

if(field1> field2 , 'Greater', 'Smaller') as Test

from excel...

then simply add the in Table..

you dont need any step else.

Re: hi QlikView users

Thu, 14 Nov 2013 09:23:43 GMT

thank you your answer.

but,

I don't know the reason you wrote:

if(field1> field2 , 'Greater', 'Smaller') as Test

actually, I want price table

If i check the product, and present the "price" list, the table like a drop box(using expression) to "count number".

plus (selected count)*price

so I prepared excel file (product, price).

Is it possible ...?

Re: hi QlikView users

israrkhan — Thu, 14 Nov 2013 09:40:55 GMT

it was just an example, if(field1> field2 , 'Greater', 'Smaller') as Test...

do you have product and price in one table or in separate tables,

show me your script? or your table image ? how data looks like? to help you better...

Re: hi QlikView users

Fri, 15 Nov 2013 00:45:01 GMT

thanks IsrrKhan

it's my xlsx file and script.

there are product, price and count in one file.

but, I want to select value without association.

like this.

when I select "A", want value "2" or "3" no "1".

I cant' ignore connection each other.

do you understanding?

Re: hi QlikView users

Mon, 18 Nov 2013 10:02:27 GMT

So simple answer.

dd:

LOAD product,

price,

count

FROM

plus.xlsx

(ooxml, embedded labels, table is Sheet1);

product:

Load product, price Resident dd;

count:

Load count Resident dd;

drop table dd;