Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Check out our latest virtual session where BARC Fellow, Doug Laney, highlighted the opportunities data monetization can offer enterprises. Watch here.
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

Current Month

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

11 Replies
Not applicable

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

Not applicable

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

NavinReddy
Creator II
Creator II
Author

Hi Robert ,

I want to show comparison of each month Dollars,

and Varible for vCurrentMonth=Apr i need to show

Best Regards,

Niranjan

Anonymous
Not applicable

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.

Not applicable

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.

preminqlik
Specialist II
Specialist II

make master calendar upto decemner

or

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

NavinReddy
Creator II
Creator II
Author

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

NavinReddy
Creator II
Creator II
Author

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

Anonymous
Not applicable

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.