topic Re: Minimum Value in Straight Table in QlikView

Minimum Value in Straight Table

manpri7078 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I want to make a straight table chart. I am attaching herewith Sample QVW as well as Sample Excel file.

My output in the table chart should be the following :

Dimension - Item names as per dimension selected. Only two Items namely Bauxite and Caustic are there in my sample file.

1st Expression : Minimum Actual Efficiency for selected rolling periods. My case is for 5 rolling periods with base period of May-17

2nd Expression : Actual Efficiency for the Selected Month. This is calculating correctly. This is not required for the chart. Only for sample presentation.

3rd Expression : Actual Issue Price for the selected Month. This is also calculating correctly.

4th Expression : I have not made this. But this should be 1st Expression multiplied by 3rd Expression

My intention is to calculate the 4th Expression to show the picture that if efficiency would have been as per 1st Expression and the rate be monthly actual as per 3rd expression, then what should be the values of my 4th expression.

If I am making individual text boxes expressions, then it can be done easily as shown in two sample text boxes.

Can you guide me that what mistake I am doing in my 1st Expression in the chart.

Regards

Manish Prasad

Re: Minimum Value in Straight Table

Anil_Babu_Samineni — Thu, 13 Jul 2017 05:40:13 GMT

Why not doing this?

Column(1) * Column(4)

Re: Minimum Value in Straight Table

Anil_Babu_Samineni — Thu, 13 Jul 2017 05:40:36 GMT

I mean

Column(1) * Column(3)

Re: Minimum Value in Straight Table

manpri7078 — Thu, 13 Jul 2017 05:44:27 GMT

Hi Anil,

I think I have not been able to make clear my query.

My 1st expression is having problem. It should have values as per two text boxes expressions one for Bauxite and another for Caustic. The Text boxes are showing correct numbers.

Hope now I am clear in my query.

Regards,

Manish Prasad

Re: Minimum Value in Straight Table

manpri7078 — Thu, 13 Jul 2017 05:47:19 GMT

Hi Anil,

Your suggestion is good but my column 1 is not calculating as per my desire. the problem is there only.

Regards

Manish Prasad

Re: Minimum Value in Straight Table

Anil_Babu_Samineni — Thu, 13 Jul 2017 05:52:34 GMT

Sounds Good !!

In technically, How is your expression looks like for expression1?

Re: Minimum Value in Straight Table

manpri7078 — Thu, 13 Jul 2017 05:58:36 GMT

Hi Anil,

I have myself solved my problem. I was doing one very silly mistake there. This should be my 1st Expression :

Min({<Period=,Product={'Hydrate'},FY, Month,[Mon-Y]={">$(=Num(Addmonths(Max([Mon-Y]),-vInputRolling))) <=$(=Max([Mon-Y]))"}>}Actual_Efficiency)

Actually I figured out just now that what mistake I was doing. Actually I copied my expression from another object and forgot to modify it as per my requirement.

Any way thanks

Regards

Manish Prasad

Re: Minimum Value in Straight Table

Anil_Babu_Samineni — Thu, 13 Jul 2017 06:00:48 GMT

Haha, NP please make flag your response as correct answer