Show all month days

[#1]

hello,

i am trying to create a line chart that showing value for each day in a month.

my problem is when i select a day, the graph is showing me value for the selected day,

i need to show all month values even if i select a day.

i know that i need to use set analysis but i dont know how.

thank you all.

[Miguel_Angel_Baeyens]

Hi,

Depending on your actual data model, if you only want to ignore the selection in Day, do the following

Sum({< Day = >} Value)

"Day =" means ignore selection in field Day.

Hope that helps.

Miguel

[#3]

thank you,

but i have day in my dimensions and value in expression.

can i do something similar in the dimensions ?

[sushil353]

use the above formula sum({<DAY=>}Value) in expression

[Miguel_Angel_Baeyens]

Hi,

I was not clear enough, sorry. Yes, the code above is for the chart expression, regardless the dimensions you have.

Miguel

[#6]

Hi Miguel,

Hope you are fine.

I have one small query in below expression :

sum( {$<~Ingredient = {“*garlic*”}>} Sales )

i dint understand the symbol '~' of this.

can you explain me what is the out put of the above expression ?

Thanks,

Antony.

[#7]

may be i wasnt clear enough,

i have dimensions:  Name , Day

and expression: Value.

my graph present days and value for each day,

i want to show all month days even if i select a day.

for exemple: if i select 30/Nov/2011 i get the value for that day, i want to show all days.

[Miguel_Angel_Baeyens]

Hi Antony,

That means that Ingredient is a Logical And Mode, meaning that by default, selections in that lisbox will be done as a logical AND instead of the logical OR (say you have Year in a listbox, and you select 2010 and 2011, by default, you are telling QlikView "return all values for year 2010 or year 2011"). You can set that option in a listbox in its properties, General tab, "And Mode". However, this option is not always available, and you need check page 138 in the Reference Manual on how to build this kind of field (field only in one table, second field in that table, table loaded using LOAD DISTINCT...).

Well, in case you have this kind of field, and you want to exclude that "And" field values, you need to add the "~" sign before the field.

Hope that helps.

Miguel

[Miguel_Angel_Baeyens]

Hi,

Again, use the code above as the expression in the chart. Did you already try it?

Regards.

Miguel

[#10]

Hi Miguel,

Thanks......