topic Calculate Min Price on frontend?? in QlikView

Calculate Min Price on frontend??

panipat1990 — Tue, 08 Nov 2016 11:43:12 GMT

Hi Team,

we have 4 dimension and one Measure fields.

Dimension:-

1. Material

2. Vendor

3. Calendar_Year

4. Month_Year

Measure:- Price

we have a requirement to calculate Minimum price(a New Measure) on frontend. From Back end that can be calculated. but we want it to get it from Front-end..

have attached the data for reference. Please help me over this.

Thanks

Gourav

Re: Calculate Min Price on frontend??

sunny_talwar — Tue, 08 Nov 2016 11:48:54 GMT

What is the expected output here? Is it 46.713522 across all the rows? If yes, then may be this:

Min(TOTAL Price)

If not, then please provide more details

Re: Calculate Min Price on frontend??

panipat1990 — Tue, 08 Nov 2016 15:24:19 GMT

Thanks Sunny.. it is working

Regards

Gourav