topic Re: Current Month in QlikView

Current Month

NavinReddy — Thu, 29 May 2014 19:06:15 GMT

Dear All,

I have 12 Months in my database

But only i have 4 months data

Month Dollars

jan 100

feb 300

mar 400

apr 700

may -

june -

july -

aug -

sep -

oct -

nov -

dec -

like this format i have data

in this data current month if i search Apr i want to show ,

and every month comparision also i can show

how can i solve this issue

please help some one

Thanks in Advance

Niranjan

Re: Current Month

Thu, 29 May 2014 19:07:52 GMT

What are you trying to actually do? I'm not sure I caught on to what the question was....

Re: Current Month

Thu, 29 May 2014 19:10:56 GMT

Your question is unclear. Please provide more information so we can help.

Re: Current Month

NavinReddy — Thu, 29 May 2014 19:25:27 GMT

Hi Robert ,

I want to show comparison of each month Dollars,

and Varible for vCurrentMonth=Apr i need to show

Best Regards,

Niranjan

Re: Current Month

Anonymous — Thu, 29 May 2014 19:28:31 GMT

Hello, Niru Niru.

Seeing your other posts, I think I know what you want. Here as an example QVW. I'm going to attach the same file to your other posts about this issue too.

Hope it helps.

Cheers.

Re: Current Month

Thu, 29 May 2014 19:28:44 GMT

You want to compare each month to the the variable you sent for current month? Do you want the current month to always be april or do you want it to be dynamic? Are you saying the problem is that you don't have enough data or that you don't know how to create charts that will show the comparisons for the 4 months of data you do have?

I'm sorry I'm asking so many questions, but you haven't been very clear.

Re: Current Month

preminqlik — Thu, 29 May 2014 19:29:45 GMT

make master calendar upto decemner

in chart go to dimensions tab and click on show all values

Re: Current Month

NavinReddy — Thu, 29 May 2014 19:37:23 GMT

yes exactly same,

it should be dynamic every month data will add

on that time some other is Current month

and i want to show comparisons of each month Dollars

Thank you somuch for your efforts

Best Regards,

Niranjan

Re: Current Month

NavinReddy — Thu, 29 May 2014 19:42:36 GMT

Hi Brono Montenegro,

Here i want to create one more expression that will show

each month dollars comparison how can i do this

please same QVW if it possible Solve it for me

Best Regards,

Niranjan

Re: Current Month

Anonymous — Thu, 29 May 2014 20:07:12 GMT

Hi, Niranjan.

I don't understand your requirement. Isn't the bar chart in the QVW comparing dollars and SQF for each month? Please try to better explain what you want.

Regards.

Re: Current Month

NavinReddy — Thu, 29 May 2014 20:11:04 GMT

sorry pivot table i want to show comparisons

Re: Current Month

Anonymous — Thu, 29 May 2014 20:24:24 GMT

Please make a mock up drawing of the result you are expecting.