topic Re: expression to write for a chart in QlikView

expression to write for a chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

my data model is as follows :-

I have 3 tables :-

1. POS_Master_all

2. Material_Master

3. store_Mapping

Here in the above master table the business is based on seasons(winter,summer,autumn,spring) and year now i want an expression to show sales in a bar chart based on seasons

need an expression to depict sales and dimension in a bar chart would be (distribution channel, category, gender).

Re: expression to write for a chart

techvarun — Fri, 11 Aug 2017 04:36:45 GMT

The problem is nice to solve with some sample data, expected result or a qvw file. share something if possible

Re: expression to write for a chart

MayilVahanan — Fri, 11 Aug 2017 04:38:21 GMT

You can use

Dimension : Seasons

Expression :Sum(Sales)

Dimension: May be create cyclic group with distribution channel, category, gender

Expression :Sum(Sales)

Re: expression to write for a chart

Anonymous — Fri, 11 Aug 2017 05:15:31 GMT

I need a single expression to be created for any season which users enters in dashboard

Re: expression to write for a chart

Anonymous — Fri, 11 Aug 2017 05:20:06 GMT

2014 year(expression written on bar chart )

=num(

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)), [inv value]))/Sales_INR_Unit,

'#,##0.0')

2014 season

=num(

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)) and [Season Code] = $(vSales_Summary_Previous_Season), [inv value]))/Sales_INR_Unit,

'#,##0.0')

I need a combined expressions for all seasons and particular year