Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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
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.
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 ...?
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...
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?
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;