Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Hide names in a top 10 table

Hi peeps,  I've made a top 10 table and I want to send it to a customer however I dont want them to see the other 9 customers names...I want them to show XXXX instead of the name eg

Customer     Sold

HMV          100

Virgin          97

OurPrice     85

The Virgin customer will get....

Customer     Sold

XXXX          100

Virgin           97

XXXX          85

You can select which 10 customers you want in the table and which one you want to single out.  Is there a way of doing this?

Thanks in anticipation

5 Replies
jafari_ervin
Contributor II

Re: Hide names in a top 10 table

Hi Jonathan,

I implemented your request with Section Access.

Please see the attachment and let me know your Idea.

User: User1,User2,User3

Pass: 123

Best regard,

sasiparupudi1
Honored Contributor III

Re: Hide names in a top 10 table

Hi

Just Curious..

How can you stop the user from using another listbox or a tablebox or a chart to display the customers in the table?

Sasi

Not applicable

Re: Hide names in a top 10 table

Hi Jafari

That's a really interesting way of doing it, and i'll use that for another task I have to complete.  However I dont need to be concerned about exposing data to the customer as this dashboard will be an internal dashboard.  Is there a way of selecting the customer in a listbox and then referring to that within the expression.  eg  could I have 2 listboxes, in one I select "Virgin" in the other I select "VIRGIN, HMV and OURPrice, then I'd like the table to say

Customer     Sold

XXXX          100

Virgin           97

XXXX          85

Can you think of a way of doing this, maybe using the "if customer=vCustomer then customer,XXXX."  how do I associate the 1st listbox with the vCustomer variable?

ramoncova06
Valued Contributor III

Re: Hide names in a top 10 table

how are you sending them this data ?

you could probably get this by using alternate state

Not applicable

Re: Hide names in a top 10 table

its being displayed on an internal dashboard.

How can I do this with alternative states?

Community Browser