topic Igroring Dimention in QlikView

Igroring Dimention

Thu, 19 Dec 2013 11:17:56 GMT

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

Re: Igroring Dimention

tresB — Thu, 19 Dec 2013 11:33:52 GMT

Have you tried like:

Count({<Date=>} ID)

Re: Igroring Dimention

Thu, 19 Dec 2013 11:52:45 GMT

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

Re: Igroring Dimention

tresB — Thu, 19 Dec 2013 11:56:29 GMT

Could you please post a sample that demonstrates the issue?

Re: Re: Igroring Dimention

Thu, 19 Dec 2013 15:36:38 GMT

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!