topic Re: Display Repeated Numbers in Dimension in QlikView

Display Repeated Numbers in Dimension

manideep78 — Wed, 22 Jan 2014 10:28:49 GMT

Dear Community,

I have different lot numbers with repeated frequency. Lot numbers will repeat any number of times.

When I use Lot number as dimension, in line chart it shows lot number only once but I need to display repeated lot numbers.

For this I used RowNo() for every lot and concatenated to lot number as a calculated dimension. But what I want is I need to display only Lot numbers and not concatenated rowno.

Please find the sample file attached

Any help will be appreciated.

Thanks a ton in advance.

Regards

Manideep

Re: Display Repeated Numbers in Dimension

Wed, 22 Jan 2014 10:48:31 GMT

hi,

If you need repeated lot no, then they must be distinguished by some attribute (like you use row no).

May be you can improve the UI, how it should be displayed to user.

Please find the attached file.

Re: Display Repeated Numbers in Dimension

sudeepkm — Wed, 22 Jan 2014 10:54:55 GMT

Please try Dual(LOT,RCount) in your dimension.

Re: Display Repeated Numbers in Dimension

Wed, 22 Jan 2014 11:00:24 GMT

Its working,...great

Re: Display Repeated Numbers in Dimension

maxgro — Wed, 22 Jan 2014 11:04:24 GMT

try with this dimension

=dual(LOT, RCount)

ops i'm late....

Re: Display Repeated Numbers in Dimension

manideep78 — Wed, 22 Jan 2014 11:38:06 GMT

Thanks Sudeep. That is what I need. Thank you guys for your contribution.

Regards,

Manideep