Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,Myself new to QlikView i'm facing a problem with Count Distinct in a POC. My problem is to find distinct columns in a Table along side need another column again disinct columns.I need Distinct columns at each individual level.
Amount | Manager | Geo-code | Office |
---|---|---|---|
500 | 001 | 020 | IND |
510 | 002 | 020 | IND |
211 | 003 | 010 | US |
211 | 002 | 010 | BRA |
500 | 001 | 010 | IND |
Output Expected as
ABC | Distinct | Distinct 1 |
---|---|---|
Amount | 3 | 2(500),2(211),1(510) |
Manager | 3 | 2(001),2(002),1(003) |
Geo-Code | 2 | 2(020),3(010) |
Office | 3 | 3(IND),1(US),1(BRA) |
I got Distinct Number but failed to get Distinct 1 column results.Please do needful
Hi,
If you are using Qlikview 11, Try Notes in Qlikview server.
From Qlikview 11 Reference Manual
Notes and Comments
The second new collaboration feature is Notes and Comments. This feature allows users to create and share
notes about QlikView objects. Notes are shared with other QlikView users and these others users can
respond by leaving their own comments. The users have the ability to save a snapshot (bookmark) of the
data with each Note and Comment.
Regards,
Jagan.
One more Question in Attached ABC excel file i need a condition count of sum of premium_gross Values Adjacent to Distinct counts done Dimensios office, Geo,manager in a pivot Table.Any set analysis has to be written
Hi,
Can you create another post so that it would be helpful for others too.
Regards,
Jagan.
started new thread Jagan,can you please help me in Set analysis to diasplay gross http://community.qlik.com/thread/130962