topic Re: write the script to derive output from input table in QlikView

write the script to derive output from input table

sonysree88 — Sat, 16 Nov 2024 21:30:52 GMT

write the script to derive output from input table

madhu_r — Tue, 29 Jan 2019 09:11:06 GMT

Hi,

Try this.

In dimension give Category and in measure give Max(Sales).

its_anandrjs — Tue, 29 Jan 2019 10:12:30 GMT

Hi,

Where you need this output

1. In Load script

2. Front end

Regards,

Anand

its_anandrjs — Tue, 29 Jan 2019 10:16:57 GMT

On load script you can try this

DBSource:
LOAD * Inline
[
Product,Category,Sales
1,x,4000
2,x,5000
3,y,2000
4,y,4300

];

MaxSales:

LOAD
Category,
Max(Sales) as MaxSale
Resident DBSource
Group By Category;

Regards

Anand