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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
balrammahato204
Creator
Creator

Problem in Straight chart and list box

Hi all,

Please help me out i have one problem in straight Chart.

1. As per my below data set i have data from Jan-14 to Jul-15. In this data set i want a list box which will be display the value from Jan-15 to July-15 and when new month will come in my data set then in my list box it will be add.

2. Now i want a straight chart and initially in this chart i want to display only current 12 months values.

it means in the default value for this data set is Aug-14 to July-15. when new month will add in my data set

then again change the default value of my chart and it will be display Sep-14 to Aug-2015(assumed month not available in my data set).

3.One more condition if i select any month in my list box then my chart value will be change and it will show from select month to previous 11 month value.

ex. if i select Feb-15 in my list box then my chart value is Mar-14 to Feb-15.

   Month                               Value 

Jan-1425
Feb-1489
Mar-1493
Apr-1475
May-1493
Jun-1415
Jul-1441
Aug-1485
Sep-1480
Oct-1461
Nov-1460
Dec-1421
Jan-1591
Feb-1528
Mar-1569
Apr-1570
May-1546
Jun-1552
Jul-1552

Best Regards

Balram

5 Replies
robert_mika
Master III
Master III

Are your Dates in Date or string format?

balrammahato204
Creator
Creator
Author

Hi robert,

My date format is MMM-YY

sunny_talwar

See if the attached (screenshots + the qvw document) is that you wanted.

Capture.PNG

Capture.PNG

Best,

Sunny

balrammahato204
Creator
Creator
Author

Hi ,

could you please upload the QVW file i am not able to find the attachement

sunny_talwar

Sure

PFA