topic Re: Load values in QlikView

Load values

Fri, 08 Nov 2013 07:17:55 GMT

Hi All,

I have one excel sheet As.

Customer	Material	CostPrice
1	A	10
2	B	10
3	C	20
4	D	30
5	A	20
6	B	10
7	C	11
8	D	23

Input Box
50

Here i want to calculate Total value based on one input box. If value in input box is 50 then i want to calculate total as 50*CostPrice.

If i directly enter Formula 50*Costprice in Total column definition. it is working for all rows. But if i use material filteration

means i selected material A then 1,5 customers has this material and i want to update these 2 rows with input box value 80 then i am getting total as 80*10 and 80*20. this is fine

but if i unselect the material A from filtration (with intention to see all materials ).This 80 value is applying to all materials.

Is there anyway to handle this ?

Regards,

Praveen

Re: Load values

kaushiknsolanki — Fri, 08 Nov 2013 07:24:32 GMT

Dear Praveen,

I am sorry but i couldn't get your problem, can you please explain with example and the sample data if possible.

Regards,

Kaushik Solanki

Re: Load values

Fri, 08 Nov 2013 07:33:14 GMT

Hi Kaushik,

Thanks for your reply. For easy understanding i modified column names. Please check the attached video. here problem is at last step after material de-selection input box value is applied to New rebate column.

I can't insert the video here, please check below link it has video file

http://community.qlik.com/thread/98264

Regards,

Praveem