Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

hi QlikView users

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.

1 Solution

Accepted Solutions
Not applicable
Author

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;

View solution in original post

6 Replies
Not applicable
Author

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

israrkhan
Specialist II
Specialist II

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.

Not applicable
Author

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

11.PNG.png

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 ...?

israrkhan
Specialist II
Specialist II

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...

Not applicable
Author

thanks IsrrKhan

it's my xlsx file and script.

11.PNG.png, 22.PNG.png

there are product, price and count in one file.

but, I want to select value without association.

33.PNG.png like this.

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

I cant' ignore connection each other.

do you understanding?

Not applicable
Author

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;