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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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