Problem in Variables in Set Analysis

[manpri7078]

Dear All,

I am attaching sample QVW and Excel files for my query.

In this document I have defined some variables. I am using two of those variables in my chart in the form of straight table where values are calculating perfect as desired.

Now I want a text box to show calculations as per desired other variables and the value which should come to 61400 which can be traced in the sample excel file attached but it is not calculating.

Want to know where I am wrong.

Regards,

Manish Prasad

[prma7799]

Hi Manish ,

Again you miss to convert [Mon-Y] field in proper date format

LOAD Particulars, Item_Grouping, Expense_Type, Unit, Product, Month,

FY, Period, Days,

date([Mon-Y],'MMM-YY') as [Mon-Y] ,

     Actual_Qty

FROM

[Sample Excel File (1).xlsx]

(ooxml, embedded labels, table is Data);

[prma7799]

Please close this thread

Variables in Set Analysis

This is really help for new qlik community member to identify right answer.

Thanks

[manpri7078]

If I am making changes in the load script my chart expression is not working.

See the attached document for this.

Previously it was working.

So I will not have to do this : date([Mon-Y],'MMM-YY') as [Mon-Y] in my load script.

Or I will have to modify my chart expression which is not calculating as per my vInputRolling Value of last 5 months data.

Can you guide me now what to do ?

Regards

Manish Prasad

[sunny_talwar · Accepted solution]

Try this

=Sum({<Period=,FY=,Month=,Days=, [Mon-Y]={"$(=Num(Date#(vInputMonth, 'MMM-YY')))"}  ,Item_Grouping={'$(vInputExpense)'},Unit={'$(vInputUnit)'},Product={'Hydrate'}>}Actual_Qty)

[Kushal_Chawda]

I think you have selected wrong Month in your application, If you select Jun 2017, 61400 value is correct

[sunny_talwar]

Know this from his OP's previous post, but he is looking for a way to drive Month selection through input field instead of regular list box selection because regular list box selection will impact the complete dashboard and he is only looking the month selection for a particular chart. I guess alternate state might be another option in this case

[manpri7078]

Thanks Sunny. Now my problem is solved.

Regards

Manish Prasad