topic Re: Budget represent in QlikView

Budget represent

warrentk80 — Mon, 09 Dec 2013 11:14:38 GMT

good morning

I need to represent in a chart table the budget month, the month and the previous month based on the month selected from a list box

tell me someone would know the expression to be inserted

thanks

Andrea

my campodata is dataannomese and in my list box, I can select the month with month (dataannomese)

thanks

Andrea

Re: Budget represent

manideep78 — Mon, 09 Dec 2013 11:21:08 GMT

Hi Andrea,

Can you be more specific? What exactly you want to show in a chart table? what were the fields involved or could you please give some sample data?

Re: Budget represent

warrentk80 — Mon, 09 Dec 2013 12:46:50 GMT

thanks for the reply.

I want to show the sum of the budget, sending an example attached

Re: Budget represent

manideep78 — Mon, 09 Dec 2013 12:52:45 GMT

For Selected Month:

Sum({<Your_Date_Field={"=Month(Date(Your_Date_Field))"}>}Your_Budget_Field)

For Previous Month:

Sum({<Your_Date_Field={"=Month(Date(Your_Date_Field))-1"}>}Your_Budget_Field)

Hope this helps

Regards,

Manideep

Re: Budget represent

warrentk80 — Mon, 09 Dec 2013 13:11:43 GMT

Thanks for the quick response.

I tried to enter the code that you sent me but in the current year and 2 columns last year I see the same value.

thanks

Andrea

Re: Budget represent

manideep78 — Mon, 09 Dec 2013 13:18:06 GMT

Could you please send me the sample Application for better understading