Depending on RowNo in the dynamic chart - user able to see text (need to download full data set) or can export from the existing one.

[ashmitp869]

Hi there,

I have a report with dynamic dimensions and measures .

My qlikview script contains the sample code:

_QR_Where_EPISODE:
LOAD * INLINE [
_dimensions_where,                                   _dimensionsNo_where
Health Org ID,                                       1
Health Org Name,                                          2

]WHERE _dimensionsNo_where <> 0;

_QR_When:
LOAD * INLINE [
_dimensions_when,                                    _dimensionsNo_when
SE End (Fiscal Year),                                9
SE End (Year),                                       10
]
WHERE _dimensionsNo_when <> 0;

_QR_Who:
LOAD * INLINE [
_dimensions_who,                                     _dimensionsNo_who

MRN Masked,                                               6
MRN,                                                 14

]
WHERE _dimensionsNo_who <> 0;

_QR_Measure:
LOAD * INLINE [
_measures,                                           _metricsNo
SE,                                                       1
LOS,                                                      2

]
WHERE _metricsNo <> 0;

My req. is I need to show the row no separate marked in blue

And if >1000 rows display, “There are X rows in your Quick Report, you will need to use the Download full dataset to view all the selected data.” 

OR

Of <1000 rows then display ““There are X rows in your Quick Report”  

and can export from the original chart (straight table)

[marcus_sommer]

Just counting the values of dimension-fields of the chart should do the job. Means something like:

count(distinct Dim1&Dim2)

whereby Dim1 and Dim2 are just placeholder for your dynamic dimensions.