Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
My first post in the community, though having been months with Qlikview.
Just would like to seek some help on how I can count the occurrence of the Value Pairs. For example, I have a table of (x,y) with values: (10,20), (15,30), (10,20), (10,20), (15,20). How can I count the occurrence of each value pair which gives:
(10,20) = 3
(15,30) = 1
(15,20) = 1
Looks simple (I guess) but I cannot find an answer from the community for a whole day search. Maybe I used the wrong keywords. Thanks in advance.
Snowman
Hello,
are this two field your datamodel like "x" and "y"?
if so first approach could be a table with
dimension: =x&y
expression: count(x&y)
maybe you want to create this pair as one column in script that you dont have to use a calculated dimension.
regards
tim
Hello.,
In data model for example you have a table
fields x and y
load x, y
x & y as pair //make this new field
from path;
do reload
take stright table
dimesion x and y
expression --> =count(pair)
---------------------------------------------------------------
directly do in front end
take stright table
dimesion x and y
expression --> =count(x & y)
----------------------------------------------------------------
Based on your requirement do as you can best
Hello,
are this two field your datamodel like "x" and "y"?
if so first approach could be a table with
dimension: =x&y
expression: count(x&y)
maybe you want to create this pair as one column in script that you dont have to use a calculated dimension.
regards
tim
Hello.,
In data model for example you have a table
fields x and y
load x, y
x & y as pair //make this new field
from path;
do reload
take stright table
dimesion x and y
expression --> =count(pair)
---------------------------------------------------------------
directly do in front end
take stright table
dimesion x and y
expression --> =count(x & y)
----------------------------------------------------------------
Based on your requirement do as you can best