topic Re: Problem in Straight chart and list box in QlikView

Problem in Straight chart and list box

balrammahato204 — Fri, 20 Nov 2020 18:02:30 GMT

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-14	25
Feb-14	89
Mar-14	93
Apr-14	75
May-14	93
Jun-14	15
Jul-14	41
Aug-14	85
Sep-14	80
Oct-14	61
Nov-14	60
Dec-14	21
Jan-15	91
Feb-15	28
Mar-15	69
Apr-15	70
May-15	46
Jun-15	52
Jul-15	52

Best Regards

Balram

Re: Problem in Straight chart and list box

robert_mika — Sun, 05 Jul 2015 01:01:39 GMT

Are your Dates in Date or string format?

Re: Problem in Straight chart and list box

balrammahato204 — Sun, 05 Jul 2015 07:53:17 GMT

Hi robert,

My date format is MMM-YY

Re: Problem in Straight chart and list box

sunny_talwar — Sun, 05 Jul 2015 12:08:06 GMT

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

Best,

Sunny

Re: Problem in Straight chart and list box

balrammahato204 — Sun, 05 Jul 2015 15:03:14 GMT

Hi ,

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

Re: Problem in Straight chart and list box

sunny_talwar — Sun, 05 Jul 2015 15:06:25 GMT

Sure

PFA