topic Re: Select distinct in pick dimensions in QlikView

Select distinct in pick dimensions

Thu, 09 Jan 2014 17:00:26 GMT

Hi,

I have created a pick dimensions chart where the user can click on a List Box and the columns he wants will appear.

I want the user to be able to do a Select Distinct like in SQL. That is for the 5 let's say columns out of 20 that he chooses, to show the distinct rows only and not all of them. The result will be different, depending on the columns he picks.

Re: Select distinct in pick dimensions

iktrayanov — Thu, 09 Jan 2014 17:13:16 GMT

Can you give us an example.

Re: Select distinct in pick dimensions

whiteline — Thu, 09 Jan 2014 17:18:51 GMT

Hi.

Don't understand the problem. If you've created this chart it should work as you described.

Could you attach an example ?

Re: Select distinct in pick dimensions

Thu, 09 Jan 2014 18:28:01 GMT

I could not understand but i hope this will help You.

C:\Program Files\QlikView\Examples\Documents\Whats new in in Qlikview\Reports(sheet).

Regards

Mahesh T

Re: Select distinct in pick dimensions

Fri, 10 Jan 2014 08:49:08 GMT

Sorry about the confusion, the mistake I made was that I had a hidden dimension and all the rows were displayed.

So, in order to avoid getting a huge table I had to use expressions, rather than dimensions. If you use only dimensions, the table gets bigger and bigger as you pick more columns, but not if you put them as expressions. That's why I used 5 dimensions and 50 expressions.

Indeed it works as select distinct when you choose a dimension, but this is not the case for expressions. I used a conditional

SubStringCount(Concat(_Name of Set, '|'), 'Column1') AND getselectedcount(_Name of Set)>0

Where Name of Set contains all these columns. So there is actually no problem, I just hadn't seen my document for a while. Sorry about the confusion!

What I am now trying to see is an easy way to show a counter of the displayed rows (not selected).

Re: Select distinct in pick dimensions

jagan — Fri, 10 Jan 2014 08:54:44 GMT

Hi,

If you want to display RowCount then try like this

=Sum(Aggr(1, Dim1, Dim2,....DimN))

-Replace Dim1, Dim2... with your dimension names in the chart.

Hope it helps you.

Regards,

Jagan.