topic Re: dimension if statement in QlikView

dimension if statement

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to create a straight table using one dimension to show to total count. This dimension has two types of values 'Auto' and 'Manual'.

How and where can I limit this table to show me the total count of the 'Auto' value only?

Or if I should be using a straight table for one dimension what should I use for the above.

Re: dimension if statement

trdandamudi — Fri, 11 Nov 2016 14:27:40 GMT

I created a sample for you and please see the attached. Hope this helps...

Re: dimension if statement

Mon, 14 Nov 2016 16:58:18 GMT

thanks for the reply.

I that the exact syntax required? I tried it (using my own var names) and didn't work as there was an error in the expression box. Also, is it not the textcount function rather than the count function required for the value = 'Auto'?

Re: dimension if statement

Anil_Babu_Samineni — Mon, 14 Nov 2016 17:03:55 GMT

T P

Would you share the Expression you have tried ver there

Re: dimension if statement

Tue, 15 Nov 2016 09:10:05 GMT

So I am trying to give a simple count of how many times the Matched column as the value 'Auto' only. I don't want to include 'Manual' at all in the result (seen in yellow and it doesn't have to be aligned like the way I made it in excel)

What's the best sheet object to use?

Re: dimension if statement

Tue, 15 Nov 2016 09:16:13 GMT

this is what I have tried which Is wrong.

count({<matched={'Auto'}>})

Re: dimension if statement

Anil_Babu_Samineni — Tue, 15 Nov 2016 09:21:29 GMT

You may try this

Count({<matched = {'Auto'}>}matched)

Re: dimension if statement

varshavig12 — Tue, 15 Nov 2016 09:22:21 GMT

May be like this,

count({<matched={'Auto'}>}matched)

Re: dimension if statement

Tue, 15 Nov 2016 09:32:07 GMT

In expresion try the below.

Count ({<matched={'Auto'}>}matched)

Re: dimension if statement

susovan — Tue, 15 Nov 2016 09:39:57 GMT

You can also try this attachment,

Re: dimension if statement

Anonymous — Tue, 15 Nov 2016 11:10:37 GMT

Hi T P

If you want that thing in dimension than you can use following and it will give you count of 'AutoData' according to Tran_Date. Means you will be able to calculate only 'Auto' Data on daily basis and its amount.

Tran_Date	Name	Count	Type	Amount
01/10/2010	A	1	Auto	120
01/01/2009	A	1	Auto	100
01/04/2009	B	-	Manual	-
01/07/2009	C	-	Manual	-
01/10/2009	D	-	Manual	-
01/01/2010	E	-	Manual	-
01/04/2010	F	-	Manual	-
01/07/2010	G	-	Manual	-
31/07/2016	I	-	Manual	-
31/07/2016	J	-	Manual	-

Following are the dimensions you can use:

Tran_Date

Name

Count:- =aggr(Count({<Type={'Auto'}>}Type),Type,Tran_Date)

Type

Amount:-=aggr(sum({<Type={'Auto'}>}Amount),Type,Tran_Date)

Note:- This is a straight table

Thanks,

Re: dimension if statement

Tue, 15 Nov 2016 13:42:23 GMT

Great that worked! it gave the result below. How do I remove the zero values from the output? So From this

Re: dimension if statement

Anil_Babu_Samineni — Tue, 15 Nov 2016 14:26:42 GMT

If this is pivot object then you may try to check the suppress null values from presentation tab.

Can you confirm me one thing, if you use the same expression then why manual data will showing