topic Re: static vs dynamic count in QlikView

static vs dynamic count

Fri, 25 Apr 2014 08:14:11 GMT

Dear All,

How if we want to count dynamic expression ?

I would like to "identify" city that has sales more than variable numbers, let say : if sales more than 150, i would like to color it red ( we can do it in tab visual cues properties )

So, after i did some setting in visual cue tab, the city new york, miami are getting red.

How if i collapse the country dimension ? how if i want to put "2" to the dynamic expression column ? ( the dynamic expression column for england will become 0, and will become 1 if the variable-parameter changed from 150 to 100, etc )

the "150" ( threshold of sales ) is a variable parameter...

any suggestion ?

thx in advance

( sorry for my bad english-typing )

country ( dimension )	city	sales
USA	Washington	100
	New York	200
	Miami	250
England	Bristol	80
	Cambridge	75
	Manchester	125

Re: static vs dynamic count

MK_QSL — Fri, 25 Apr 2014 08:23:55 GMT

Don't understood clearly from your explanation.

Can you please elaborate little more?

Re: static vs dynamic count

Fri, 25 Apr 2014 08:57:52 GMT

thx for the reply

what i meant : if the data in "expand all", i easily can identify which row should be notified ( by visual cue tab )

but, if i do collapse ( to the dimension country ), i would like to "notify" the records by summary/count of row numbers

Re: static vs dynamic count

MK_QSL — Fri, 25 Apr 2014 09:00:26 GMT

Use below in expression for dynamic expression

Dimensionality()