Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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!Smiley Happy

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

Re: hi QlikView users

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;

6 Replies
Not applicable

Re: hi QlikView users

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
Valued Contributor II

Re: hi QlikView users

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

Re: hi QlikView users

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
Valued Contributor II

Re: hi QlikView users

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

Re: hi QlikView users

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

Re: hi QlikView users

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;

Community Browser