Variables in Set Analysis

[manpri7078]

Dear All,

I want one help. I am attaching sample QVW file as well as sample excel file for this purpose.

In the qlikview document first text box is showing quantity for the month and FY in selection as correct.

Now I have defined three variables and created three input boxes for them and have selected the three desired values in those three input boxes. Now I am trying to use those variables in set analysis expression in second text box. I want the result to come to 61500 as can be seen from the sample excel file example, the row which I have marked as yellow Row No 34. I want to know what wrong I am doing in defining set analysis expression. The second text box is independent of any selection in the list boxes there.

Hope I have clarified in my qlikview document what I want.

Regards,

Manish Prasad

[prma7799]

Please try

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

[manpri7078]

No still not working. I have attached my final qlikview document after all these corrections.

Regards

Manish Prasad

[prma7799]

You are missing this

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);

[manpri7078]

Thanks. It is now working. I could not figure this problem that the load script has to be changed.

Regards,

Manish Prasad

[manpri7078]

I am using following expression some where else :

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

In this expression, I am using another variable vInputRolling to make the bar chart for last n months if the current month is selected.

After making changes in the load script the above expression is not working now. Can you guide me what I have to do to this type of expressions which I am using in many objects in my working.

Regards

Manish Prasad

[prma7799]

Please create new thread for this and close this thread

[prma7799]

Please close this thread marking as correct or helpful answer.