Need help for a straight table

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have developed a QVW using as of table concept and need help for calculating previous month, day and years sum(Sales).

You can see that I have made two table : AsOfTable and AsOfTableMonth

and need to know that is there any other way to combine all these table into one as I need to show 'Order Date' column as a dimension in the chart. So whenever I add AsOfOrderDate', 'AsOfMonth' and add the following expressions it gives me wrong results:

1. sum({<FlagDate={'Current Date'}>}Sales) - for current date

2. sum({<FlagDate={'Previous Date'}>}Sales) - for previous day date

3. sum({<FlagMonth={'Current Month'}>}Sales) - for current month

4. sum({<FlagMonth={'Previous Month'}>}Sales) - for previous month

So in my chart with title: 'Sales With Order Date' gives me wrong result for current month and previous month, as because they show the same values there.

So please give me an other idea to modify my script will help to overcome this problem.Also I need to show the previous week, year and last 9 months data also in the same Straight table.

Thanks,

Sandip

Re: Need help for a straight table

Anil_Babu_Samineni — Tue, 02 May 2017 07:18:50 GMT

Can you share excel file of

Re: Need help for a straight table

Tue, 02 May 2017 10:03:39 GMT

Hi,

I have uploaded the sample data. Please use it for reference.

topic Need help for a straight table in QlikView

Need help for a straight table

Re: Need help for a straight table

Re: Need help for a straight table