topic Re: Show Yesterdays data in straight chart in QlikView

Show Yesterdays data in straight chart

rupaliqlik — Sat, 16 Nov 2024 21:14:37 GMT

Hi All,

I have some records for March Month.In one of charts I just want to show yesterdays' business.I created vYesterday Value,and pass into the expression .But it can not fulfill the requirement.I have attached application with sample data.Kindly help me.

Thanks,

Rupali Ethape

Re: Show Yesterdays data in straight chart

trdandamudi — Thu, 14 Mar 2019 13:39:41 GMT

Please see the attached file for the solution. Hope this helps..

Re: Show Yesterdays data in straight chart

Marcos_rv — Thu, 14 Mar 2019 13:43:12 GMT

Good, mmmm you go that function, you could send me what is the graph or table that you want to show ???
first of all, if you have a table where the dimension you use in the analyisys set would tell you that it will not work, it will always give you the values related to that dimension.

in the graph that was in your qvw that we passed you add a more metric, only contains the variable that you defined, here is another topic, when you define a variable it does not contain the value, it contains the calculation (max (Date)), and if in a graph use a max (Date) but you have the dimension Date, the value of max (Date) will always be Date of the record.

Regards!!!