
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Select distinct in pick dimensions
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.
- Tags:
- new_to_qlikview


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you give us an example.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi.
Don't understand the problem. If you've created this chart it should work as you described.
Could you attach an example ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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).


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
