topic Re: Problem in Variables in Set Analysis in QlikView

Problem in Variables in Set Analysis

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

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

Re: Problem in Variables in Set Analysis

prma7799 — Wed, 28 Jun 2017 08:05:25 GMT

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

Re: Problem in Variables in Set Analysis

prma7799 — Wed, 28 Jun 2017 08:06:57 GMT

Please close this thread

Variables in Set Analysis

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

Thanks

Re: Problem in Variables in Set Analysis

manpri7078 — Wed, 28 Jun 2017 08:16:48 GMT

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

Re: Problem in Variables in Set Analysis

sunny_talwar — Wed, 28 Jun 2017 08:54:53 GMT

Try this

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

Re: Problem in Variables in Set Analysis

Kushal_Chawda — Wed, 28 Jun 2017 08:56:44 GMT

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

Re: Problem in Variables in Set Analysis

sunny_talwar — Wed, 28 Jun 2017 08:59:34 GMT

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

Re: Problem in Variables in Set Analysis

manpri7078 — Wed, 28 Jun 2017 09:10:19 GMT

Thanks Sunny. Now my problem is solved.

Regards

Manish Prasad