Igroring Dimention

[#1]

Hi!

I'm trying to create a line graph with one dimension (a cycle of date- year-> Qtr->month->week).

I wan't to count ID's ignoring date- but the count should be affected from all other selections on sheet.

any help? I know if I will use {1} the qlikview will ignore both dimentions and selections and it's not what I need.

Thank you

[tresB]

Have you tried like:

Count({<Date=>} ID)

?

[#3]

yes I tried.. the dimension is a cycle so it should be:

Count(distinct {<year=,qtr=, month=, week= >} ID) but it dosen't do the work. it still doesn't ignore the dimention..

[tresB]

Could you please post a sample that demonstrates the issue?

[#5]

Hi,

I attached an example.

Instead of the expression in the chart I wan't to do something like this:

(a)/(b)

when

a= sum(money) as I wrote in the example

b= count(distinct Id's) when it is ignoring date1 (one of the diemenntions in the chart), not ignoring status (the other dimention) and it is Influenced from the date field in te sheet.

thanx!