Min and Max formula form excel to QlikView

[#1]

Hi,

I have an excel sheet with sales Data uploaded to QlikView, however I need to min and max valued need to be extracted form it by QilkView, it is possible?

[ashfaq_haseeb]

Hi you can simple use MIN() and MAX() functions.

Regards

ASHFAQ

[#3]

In QV or should I add it in excel and upload it?

[ashfaq_haseeb]

In QV.

After loading data in QV write below in text object

=Min(Sales)

=Max(Sales)

Regards

ASHFAQ

[jagan]

Hi,

Create a straight table and add the required dimension and in expression, use

=Min(Sales) for getting minimum sales

=Max(Sales) for getting minimum sales

Regards,

Jagan.

[#6]

Thanks a ton
Jagan and Ashfaq, however is it possible if I use an Array {=MIN(IF(Condition))} ?

or can I directly use the excel formulas in QV?

[ashfaq_haseeb]

Hi,

You can use MIN and Max functions in Qlik.

Even you can use excel formulas with slight modification supported by Qlik.

Regards

ASHFAQ

[MWiciok]

Hi,

I am not sure what you exactly want. Do you want to get the Minimum SALES depending on how many conditions? If you got just one condition, you can use MIN(IF(...)), but I always recommand SET ANALYSIS.

[#9]

Thanks Matthias,

Yes only one condition, cause I want the Max sales as per area and within area. For e.g. Country as USA and region as Atlanta, Ohio etc.  So if I select Country then it should be Max in USA, however if I select a Region then it need to be Max in that Region of that Country.

[jagjivvt]

Hi,

In load script use min() and group by area, you would need to load this twice for both min and max and then left join to the original table.