topic Re: ignore the dimension in QlikView

ignore the dimension

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

Help, people are kind. Sorry for my english (translator)

How can I make the numbers in the second column in all dimensions (measurements from another table, so, accordingly, he does not count on them). We can say that he ignored the second dimension.

The first measurement of the MonthYear, second - Experience

should work out like that. is this real?

Re: ignore the dimension

devarasu07 — Tue, 24 Oct 2017 05:38:33 GMT

Hi,

You can ignore the dimension like this using set analysis in your measure expression

=sum({$<MonthYear=>} Measure)

P.s: In your chart, to show the MonthYear repeat value try to use stright table instead of pivot table

Thanks,

Deva

Re: ignore the dimension

tresB — Tue, 24 Oct 2017 05:43:19 GMT

Using TOTAL in the expression should work. Try something like:

=Sum( Total <Experience> Sales)

Adjust to fit in your context.

Re: ignore the dimension

shilina_klara — Tue, 24 Oct 2017 05:45:17 GMT

Hello!

thanks for the advice.

I tried this method, but it does not work, I do not have one expression inside the set analysis

Re: ignore the dimension

shilina_klara — Tue, 24 Oct 2017 05:55:32 GMT

Hello!

and so I also tried it, it calculates incorrectly

Re: ignore the dimension

tresB — Tue, 24 Oct 2017 05:57:58 GMT

Could you share your sample qvw?

Re: ignore the dimension

shilina_klara — Tue, 24 Oct 2017 06:05:46 GMT

Unfortunately, I can not share data, because there is confidial information.

There is a Payroll fund table, where there are many columns and one of them is Month / Year and Active number for people (each line is a person).

There is a table Dismissed, where too many columns, including Month \ Year and Experience for people (each line is a person).

And I can do it the way that I ask you to help, or how to pull up the date of dismissal to the Payroll fund table/

Re: ignore the dimension

tresB — Tue, 24 Oct 2017 06:15:44 GMT

You don't have to share your actual qvw. You can always create a sample qvw with mock data and share. With sample to work on, it becomes easier for us to help. Preparing examples for Upload - Reduction and Data Scrambling

Re: ignore the dimension

Anonymous — Tue, 24 Oct 2017 06:41:23 GMT

How about

=Sum( {1 <Experience>} Sales)

Re: ignore the dimension

Kushal_Chawda — Tue, 24 Oct 2017 06:59:09 GMT

what is your second column expression?

Re: ignore the dimension

shilina_klara — Tue, 24 Oct 2017 07:43:50 GMT

at the moment, like this:

Sum( {$<bias = {'0'}, Experience = >} [Active number])

Re: ignore the dimension

shilina_klara — Tue, 24 Oct 2017 08:29:58 GMT

strictly do not judge, please, this is my first experience)

how could I cut all the data

Re: ignore the dimension

Kushal_Chawda — Tue, 24 Oct 2017 09:20:26 GMT

try this

Sum(total <МесяцГод>{$<?Смещение = {'0'} , [Категория стажа ТиО] = >}[Активная численность])

Re: ignore the dimension

shilina_klara — Tue, 24 Oct 2017 09:25:18 GMT

Hooray, this is what I need!

thank you very much! You are a genius!

Re: ignore the dimension

Kushal_Chawda — Tue, 24 Oct 2017 09:31:32 GMT

Glad that it was helpful

Re: ignore the dimension

tresB — Tue, 24 Oct 2017 09:32:43 GMT

The working expression:

Sum(TOTAL <МесяцГод> {$<?Смещение = {'0'} , [Категория стажа ТиО] = >}[Активная численность])

Edit: I am late.

Re: ignore the dimension

Kushal_Chawda — Tue, 24 Oct 2017 09:41:47 GMT

tresesco‌ let us take advantage sometime

Re: ignore the dimension

tresB — Tue, 24 Oct 2017 09:47:13 GMT

When such great helping people like you are around, the main advantages lie with the OP though.

Re: ignore the dimension

shilina_klara — Tue, 24 Oct 2017 09:54:50 GMT

And then one more question can be asked, how to transform all this beauty into a circular diagram, the measurement of the experience?

Initially, the picture was for the last month, and when you select a filter - the selected date

sorry for the arrogance, I just thought it would be easier

ADD: when I put a filter on the date everything is considered, but when there is no filter, it does not count, it can be done so that this chart has always been calculated for the maximum MonthYear?

Re: ignore the dimension

Kushal_Chawda — Tue, 24 Oct 2017 10:25:44 GMT

True. But when a legend like you already replied to the OP, it is 1 % chance that I would get correct answer.