Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

expression to write for a chart

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).

4 Replies
Specialist II
Specialist II

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

Hi

You can use

Dimension : Seasons

Expression :Sum(Sales)

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

Expression :Sum(Sales)

Thanks & Regards,
Mayil Vahanan R
Creator II
Creator II

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

Creator II
Creator II

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